Default settings for Zero Length

[Dave]

When I create a new database table, and use a text field Allow Zero Length
is always set to "No". Is there a way to set the this defaults value to yes
whenever a new table is created?

Presently, I go through the table and have to catch every text type field.

Dave

 

[Brendan Reynolds]

Ah, so *you* are the guy who thought that was a good idea! The rest of us
have been wondering who you were ever since Microsoft changed the default in
Access 2002!

Sorry, short of moving to Access 2002 or 2003, there isn't any way to change
the default. If it's any consolation to you at all, the rest of us are
thoroughly fed up with having to change it to 'No' in the later versions.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.