enable/disable

G

Guest

I have two text boxes [first time] and [second time]

Everytime a new record is added I disable [second time]

Now, how can I code [first time] to enable [second time] after the user
enters a valid time? Note, if the user skips or leaves [first time] blank, it
should enable [second time].

I have this in (afterupdate) in the [first time]:
me.[second time].enable
But, if this [first time] is empty, it still enables [second time] I want to
avoid this and make sure there is a valid time entered first. Thanks
 
D

Douglas J Steele

Try:

If Len(Me.[first time] & "") > 0 Then
me.[second time].enable
End If

The reason for the & "" is to handle both Nulls and blanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top