Re: Allow Zero Length in ADO with VB6



darklynx489@xxxxxxxxx wrote:
<a

href="http://support.microsoft.com/kb/q297980/";>http://support.microsoft
..com/kb/q297980/</a>
is a great help when applying autoincrement, but the code for allow
zero length doesnt seem to work.

I set the Allow Zero Length to True, but it still doesnt show up in my
database.
hmm?

Unfortunately, some properties set via ADOX fail to be reflected in the
Access design view of the table, especially when viewed too quickly (Jet
uses delayed-write optimization). Have you tried closing and reopening
Access to check to see if the property "took"? Have you tried running
some code in VB6 to verify that the field is allowing zero-length
strings? Are you confusing zero-length strings with null ("required"
property)?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.



Relevant Pages

  • Re: OT-Joe is back...EL ZERO SEZ, "THE SKY IS FALLING, THE SKY IS FALLING IN ON ME! WHERE CAN I
    ... EL ZERO SEZ, "THE SKY IS FALLING, THE SKY IS FALLING IN ON ME! ... sad to report but that garden variety troll (and troll ... newsgroup book---letting a troll sucker him, ... And according to one observer, a long-time member of RORT, El ...
    (rec.outdoors.rv-travel)
  • Re: PWA Timesheet and not entering a Zero value in actual Work
    ... please post your Project Server questions in the ... microsoft.public.project.server newsgroup as this newsgroup is devoted to ... the task update and processes it into the Microsoft Project plan, ... asking to me why PWA doesn't understand a null to be as a zero. ...
    (microsoft.public.project)
  • Re: Page 0 (zero) problem
    ... Microsoft's Legal Users' Guide) http://addbalance.com/usersguide ... This message is posted to a newsgroup. ... I've inherited a 6 page Word document from a former colleague and have ... How do I get rid of the page 0 (zero) on the first page? ...
    (microsoft.public.word.formatting.longdocs)
  • Re: PWA Timesheet and not entering a Zero value in actual Work
    ... Sorry about posting in the wrong newsgroup. ... The idea to entering a zero is use as an easy way for the project manager to ... the resource only forget to enter his time. ...
    (microsoft.public.project)
  • Re: Word XP - Strikethrough Font & More oops
    ... This will display a box with EQ in it. ... Between the parentheses, type 0,/ (zero, comma, slash). ... please post all follow-ups to the newsgroup so ... "Tony C" wrote in message ...
    (microsoft.public.word.printingfonts)