Labels

On one of my forms I have a label that displays an email
address that every once and awhile needs to be changed. I
don't want the user to go to design view to change the
label. Does anyone know of a way the label can be changed
in form view. Is there such a thing as a text label, or
even something I could code so that they can edit the
label?

On Mon, 23 Aug 2004 08:46:04 -0700, "David"
wrote:

On one of my forms I have a label that displays an email
address that every once and awhile needs to be changed. I
don't want the user to go to design view to change the
label. Does anyone know of a way the label can be changed
in form view. Is there such a thing as a text label, or
even something I could code so that they can edit the
label?

I would suggest having a small one-row table for this field (and other
"administrative" fields, such as perhaps your company logo); instead
of a label, use a textbox with a DLookUp() function to display the
address from this table.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public