Hide fields that are have a null value.

[Vadimbar]

Hello I have an IT tracking Db. I set up a scan option field ("Bar code ID"
when equipment is sent out. I would like have this field hidden until the
equipment is ready to be sent. Once the equipment is sent that rec gets a
value assigned to "Bar Code ID" then and only then do I want the field to be
visible. Yet in other rec where the item is still in house the “Bar code ID"
field should remain invisible. Is this possible?
Thank you,
Vadimbar...

 

[ruralguy via AccessMonster.com]

If you are talking about a control on a form then use the Current event of
the form to set the Visible property of your [Bar code ID] control.

 

[Klatuu]

In design mode, make the control's visible property No.
At the point in time where the value is assigned:
Me.BarCodeID.Visible = True

To keep those that don't have a value assigned from showing. use the form's
current event:

If Me.NewRecord Or IsNull(Me.BarCodeID) Then
Me.BarCodeID.Visible = False
Else
Me.BarCodeID.Visible = True
End If