Changing fiedl to "Not Visible" with code.

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a field on a form that I need to display only when the field
has content so that when it is empty nothing shows.

Is this possible?

Thanks,

Robin Chapple
 
I have a field on a form that I need to display only when the field
has content so that when it is empty nothing shows.

Is this possible?

Thanks,

Robin Chapple
Click to expand...
Hi Robin,
You could set the .Visible property of the control in the Current event of your
form.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
I have a field on a form that I need to display only when the field
has content so that when it is empty nothing shows.

Is this possible?

Thanks,

Robin Chapple
Click to expand...

Code the Form's Current event:
Me![ControlName].Visible = Not IsNull([ControlName])

Question. The control is null and therefore not visible. How do you
then get to enter data into it?
 
I have a field on a form that I need to display only when the field
has content so that when it is empty nothing shows.

Is this possible?

Thanks,

Robin Chapple
Click to expand...

Code the Form's Current event:
Me![ControlName].Visible = Not IsNull([ControlName])

Question. The control is null and therefore not visible. How do you
then get to enter data into it?
Click to expand...

The use is a display version where there are so many blank fields that
the appearance will be improved if they are not visible.

A separate version will be used for data entry.
 
Back
Top