Text box to Null

[Bob]

I cant get my textbox to show Null if there is nothing entered in it, Went
to tables , Design view, Default Value and entered Null, but it does not
show on my Form


Thanks in advance.........Bob Vance

 

[Graham R Seach]

Er, Bob, what do you expect a Null to look like?

What are you really trying to do?

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia

 

[Bob]

Just want to put any word in the textbox if it is empty..Bob

 

[Graham R Seach]

Bob,

If Len("" & Me.txtMyTextbox) = 0 Then
Me!txtMyTextbox = "Blah, blah, blah"
End If

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
---------------------------

 

[Bob]

Graham where do I enter this script....Thanx Bob

Bob,

If Len("" & Me.txtMyTextbox) = 0 Then
Me!txtMyTextbox = "Blah, blah, blah"
End If

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia

 

[Graham R Seach]

Bob,

<<where do I enter this script>>
I don't know. You have to tell me what triggers this to happen.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
---------------------------