asked on

Allow Zero-Length Property with SQL

Hi VB fans
I have a problem

I need to use the CRATE TABLE
sql statement and create some new table with TEXT fields in MS ACCESS DataBase.

I want to set the Allow Zero-Length property to each of these TEXT fields in my new table through
the SQL statement, how can I do that???

Thank you

Pavel Tsekov

dredge

use the NULL modifier.

CREATE TABLE MyTable
(
MyText Text NULL
)

Anthony Perkins

Unfortunately it looks like the NULL or NOT NULL in Access (at least in version 97) only changes the Required property not the Allow Zero Length property. I suspect that to set the Allow Zero Length you will have to use ADOX.

Anthony

ASKER CERTIFIED SOLUTION

bobbit31

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

amp072397

paul_tsekov:

Kindly return to and address this open question.

thanks!
amp
community support moderator

Moondancer

Please update and finalize this question. Experts, please provide closing recommendations if this remains open another seven days.

Thank you,
Moondancer - EE Moderator

DanRollins

Hi paul_tsekov,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

Accept bobbit31's comment(s) as an answer.

paul_tsekov, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer

Netminder

Per recommendation, force-accepted.

Netminder
CS Moderator