Hi All
I'm only a beginner when it comes to VBA and Access so I'd really appreciate some help.
I'm trying to enable a button on a form, only when a certain textbox has been populated ( text entered ).
I'm reading Beginning Access 2002 VBA, but I'm only a couple of hundred pages into it and I haven't so far been able to figure this one out.
Thanks
Regards / Fred

Hi, Fred. Welcome to P2P!

To enable a button only when a textbox is filled, put this on the form's ON CURRENT event and also in the textbox's AFTER UPDATE event.

Me.cmdMyButton.Enabled = Not IsNull(Me.txtMyTextBox)

Where you put your REAL names for cmdMyButton and txtMyTextBox. Basically, if the textbox is empty (null), the ISNULL function returns TRUE. The NOT in front turns the TRUE into FALSE. Therefore, the enabled becomes FALSE and button dims. If the textbox is not empty ISNULL returns FALSE. The NOT turns that into a TRUE, the enabled property turns into TRUE, and the button can be clicked.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Great!
Thanks heaps.No doubt I'll come back for more basic questions.

Cheers / Fred