Field Visibility

[NICK READ]

Is it possible to create some code that would mean that
once of the navigation buttons at the bottom of an Access
database has been clicked that a field becomes invisible

 

[Rick B]

Sort of.

You could insert code in the "On Current" property which is used every time
the user moves the focus to a different record.

NameOfField.Visible = False

You need to be more specific. There must be instances where you want it
visible and instances where you don't. You will need IF statemenst to
accomplish that.

Post back with more details if you can't figure it out.

Rick B

Is it possible to create some code that would mean that
once of the navigation buttons at the bottom of an Access
database has been clicked that a field becomes invisible

 

[NICK READ]

Thanks

There is a problem, i open the form in the design mode and
right click it and select properties the event proceedures
such as OnClick, OnMouseUp etc are displayed.

However the event proceedure OnCurrent is not displayed.

Also details of it use are displayed on the help menu.

Can you help?

 

[Rick B]

OnCurrent relates to the form, not the field. It is activated as you move
from one record to another. You need to look at the form's properties.
This is where you can insert code that runs when a form opens, when it
closes, etc.

The easiest way to get there is to go into design view and double-click on
the black square on the far left side of the screen just above the form
header to the left of the ruler.

Rick B


Thanks

There is a problem, i open the form in the design mode and
right click it and select properties the event proceedures
such as OnClick, OnMouseUp etc are displayed.

However the event proceedure OnCurrent is not displayed.

Also details of it use are displayed on the help menu.

Can you help?