Jan 7 2010, 02:30 PM
Is there a way to make a form not display a field if a another field is empty?
I'm using my AutoID for the Registration number for the Companies we register.
We already have numerous companies in the database, both registered and unregistered.
So, they all have "a registration number".
When someone looks up a certain company, the number and reg date are displayed on the Form.
I would like to fix it so if the date field is blank, the AutoID doesn't display.
Jan 7 2010, 02:48 PM
I think in the OnCurrent event of the form you could have something like (assuming you have your date field set up to take a date value or null):
If IsNull(Me.YourDateControlName) Then
Me.YourAutoIDControlName.Visible = False
Me.YourAutoIDControlName.Visible = True
Jan 7 2010, 05:39 PM
My RegDate field is setup as a Date field.
If IsNull(Me.RegistrationDate) Then
Me.PCCID.Visible = False
Me.PCCID.Visible = True