Question
Need to apply a label based on db content
Hi, I have an Access database given to me by a client, and I
can't change anything about it because of other uses that the db is
put to other than the website.
Within the db is a table that holds a field called address type. That address type could be business or private. My problem is that the entry in to that field is either a B or a P to indicate what sort of address it is.
What I need to be able to do is replace the B or P with Business or Private ,but have no idea on how to do so. Has anybody got any ideas?
The closest I can think of is using a static drop down menu and take the value and apply a label to it, but I don't want a menu, I need basic text to display.
Thanks
Mat
Within the db is a table that holds a field called address type. That address type could be business or private. My problem is that the entry in to that field is either a B or a P to indicate what sort of address it is.
What I need to be able to do is replace the B or P with Business or Private ,but have no idea on how to do so. Has anybody got any ideas?
The closest I can think of is using a static drop down menu and take the value and apply a label to it, but I don't want a menu, I need basic text to display.
Thanks
Mat
AdChoices