Hide Text Box Depending on Content

[Ed Bitzer]

Trying unsuccessfully to hide a text box on a continuous form depending
on its content for a particular record. Have tried using in the control
source =IIf([notes] Is Null,me.notes.Visible=0,[notes]) which is
changed to =IIf([notes] Is Null,[me].[notes].[Visible]=0,[notes]) by
Access and displays a 0 if the field is null - hardly what I expected.

Appreciate some guidance,

Ed

 

[dan artuso]

Hi,
Try the form's Current event for this.

If IsNull(Me.Notes) Then
Me.Notes.Visible = False
Else
Me.Notes.Visible = True
End If

One thing to remember whem dealing with continuous forms,
unbound controls will not behave as you expect since they are all
really the *same* control. Access just makes it look like they are seperate
controls.

 

[Ed Bitzer]

Dan,

I don't know that I forgot, just never though about and once reminded,
can certainly invasion why they really are the *same* control.

Hoped maybe your suggestion would work but appears the *same* control
logic holds for the current event. If the first record read has notes
then all are visible, if the first record is null all are blank.

Hope you have some other work around

Ed