Making Label visible/invisible

[Guest]

I finally figured out how to make fields visible/invisible based on a
checkbox (yes/no) option. However, I am having problems with a Labelbox.

Here is the setup: I have a vehicle service table that the primary key
(ServiceID) and the VehicleID (relational field to table that contains info
about each vehicle, ie make, model, year, color, etc). These are the first
two fields that a user encounters in this table. For the ServiceID, I wanted
to have a labelbox appear to give instructions on the format for that field.
For the VehicleID, I wanted to list the actual ID for the vehicle using a
labelbox. For both labelboxes, I wanted it to appear/disappear according to
which field was being prompted for input.

When the new record appears for the Service table, the cursor is already in
the ServiceID box awaiting input. What needs to be programmed, and how, in
order to have it's respective labelbox become visible? I figure I can use
AfterUpdate to have the label box disappear.

If it matters, I use Office XP.

Thanks in advance for your help,
Les

 

[Steve Schapel]

Les,

It may suit your purposes to enter your instructions into the ControlTip
Text property of the textbox on your form.

Otherwise, if you are talking about a Label control, you could perhaps
toggle its Visible property on the Enter and Exit events (instead of
After Update) of the data controls.

 

[Guest]

Sorry I am late getting back to you. This worked. Thank you!! I was not
sure what the On Enter/On Exit was for.

 

[Steve Schapel]

Very good, Les. Best wishes with the rest of your project.