Changing fiedl to "Not Visible" with code.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robin Chapple - 31 Jul 2006 22:44 GMT

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

Reply to this Message

RuralGuy - 01 Aug 2006 00:10 GMT

>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.
[quoted text clipped - 4 lines]
>
>Robin Chapple

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.

Reply to this Message

fredg - 01 Aug 2006 00:28 GMT

> 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.
[quoted text clipped - 4 lines]
>
> Robin Chapple

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?

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Robin Chapple - 02 Aug 2006 04:22 GMT

>> 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.
[quoted text clipped - 10 lines]
>Question. The control is null and therefore not visible. How do you
>then get to enter data into it?

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.

Reply to this Message