[lee6]

how do i make : Allow Zero Legth = yes

i know : .CreateField("Name", dbText, 95)

Thanks
lee

[Rockn]

Are you trying to do this programatically or are you attempting this from the table design view?

Nevermind...I should have read it first!!

Add another line like this:
Fields("Name").AllowZeroLength = True

[lee6]

Thanks Rockn ! !