Need to apply a label based on db content

Question

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

Newsgroup_User · Answer

if label="B" then response.write("Business") else response.write("Private")
end if

If you've got more than two choices, use "select case" instead (see
www.w3schools.com, Learn VBScript section for specifics).

"label" above is a stand-in for wherever you've stored the address type;
replace it with your local variable or recordset field reference.

"matthew stuart" <webforumsuser@macromedia.com> wrote in message
news:f14hu0$b6j$1@forums.macromedia.com...
> 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?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded