If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Field Visibility
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 |
#2
|
|||
|
|||
Field Visibility
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 "NICK READ" wrote in message ... 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 |
#3
|
|||
|
|||
Field Visibility
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? -----Original Message----- 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 "NICK READ" wrote in message ... 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 . |
#4
|
|||
|
|||
Field Visibility
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 "NICK READ" wrote in message ... 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? -----Original Message----- 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 "NICK READ" wrote in message ... 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 . |
Thread Tools | |
Display Modes | |
|
|