Hide/Show Textbox when it is null/not null(Access Form)

[adeebarsad]

Hi everyone!
I am creating 2 forms. One form when you click a specific test, it will open another form which shows all the information about the test. Some tests does not have any information/not available so it will just show an empty textbox when there is no data. I want the empty field/textbox to be hidden if there is no data/null and only to be shown if it is not null.


I've tried using the After_Update event on the textbox but can't get it work:
If Me.txt42 = "" then
Me.txt42.visible = true
else
me.txt42.visible = false
End if

[andy49]

If isnull(me.txt42) = true then

You may also have to use me.refresh to refresh the record source.


Sent from my iPhone using Tapatalk

[CJ_London]

assuming this is not a continuous form, try

me.txt42.visible=not isnull(me.text42)

[Missinglinq]

There's a several problems with your approach.

If Me.txt42 = "" Then

only checks for txt42 being populated with a Zero-Length String...while 'empty' Controls in Access usually are Null...not populated with ZLSs.

Andy49's and Ajax's suggestion of using IsNull() is a better approach.

Even better is something like this

If Nz(Me.txt42, "") = "" Then

which checks for both ZLSs and Nulls!

The After_Update event on the textbox will only fire if data is entered into the Control...or deleted from the Control...and will only be Null if data is entered and then deleted. If the Control is just ignored...never entered...it will also not fire! You can only reliably check whether a Control is populated or not using the Form_BeforeUpdate event.

...I've tried using the After_Update event on the textbox

This would suggest that the Form is being used for Data Entry, which begs the question...how can you later enter data in this Control, if need be (if it later becomes available) if it is no longer Visible?

Linq ;0)>

data

[adeebarsad]

Thank you all for the response! I got it work already. Should have used On Current Event instead of After_Update. That was my mistake.