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