how to allow empty fields

[mag]

If the Level field on my form is empty ( which sometimes can be intentional )

I get an error
"cannot be zero length string"
How can I set this field to accept nothing or to be populated

this is the after update code :

Private Sub Combo26_AfterUpdate()
Me!Unit = Combo26.Column(0)
Me!Location = Combo26.Column(1)
Me!Level = Combo26.Column(2)
End Sub

Access 2000
& win2k
cheers............

 

[WayneRyan]

mag,

You don't do this in code. It is a property of your tables
design mode.

Wayne

 

[mag]

the data type is text on table

Hello

WHich property on my table is it ?

the data type is text ...is that what you mean

 

[WayneRyan]

Maggie,

On a text field, the "Allow Zero Length" is the third property
from the bottom.

Wayne

 

[mag]

cheers....

thankyou all is good now