How to make a MS Access field 'Allow Zero Length' = true

Posted on 2004-09-10
Medium Priority
Last Modified: 2010-04-05
How to make a MS Access field 'Allow Zero Length' = true from delphi
in CREATE database dunction?
Question by:djuzoran
  • 3
  • 2
LVL 23

Expert Comment

by:Ferruccio Accalai
ID: 12025222
You mean a Text field?
If you do not specify nothing it is intended as it can accept zero length, otherwise it must be declared as Not Null

for example:

create table MyTable(MyField Text(10), //accept zero length
                               MySecondField(19) not null, //value is required
                               MyThirdField Integer);


Author Comment

ID: 12025233
MyField Text(10)

is not the same as

MyField Varchar(10) ?

LVL 23

Expert Comment

by:Ferruccio Accalai
ID: 12025267
Yes it's the same, btw forgot mi last comment, it's about required property, not zero length, sorry
Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.


Author Comment

ID: 12025293
So what should i write for nullable and zero length column?

LVL 27

Accepted Solution

kretzschmar earned 500 total points
ID: 12025329
LVL 23

Expert Comment

by:Ferruccio Accalai
ID: 12025346
Well i was looking at it at all but look at here also http://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3BQ217156

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment. Powered …

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question