Minggu, 05 Oktober 2014

[MS_AccessPros] fields visible if not null

 

Hi all, I'm trying to show in a form, fields (and labels) only if they are not null.
field by field I can do in this way:
____________________________
Private Sub Form_Current()

'If IsNull(FIELD1) Or FIELD1= "" Then

'    FIELD1.Visible = False

Else

     FIELD1.Visible = True

end If

end sub

____________________________

there is the possibility in your opinion to let MSaccess check on current event ALL fields in the form and apply the visible property if each field is not null?

Thanks for your support
Luigi

 

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar