Zero length fields in access database

[ronis]

I have an access database set up not to accept zero-length fields, but they aren't required. What can I do to my coding so that the blank fields don't bomb the code. I seem to be very confused, in Visual Basic all I did was add a "" to the string and it worked fine. Any help would be greatly appreciated.

Thanks.

 

[NickBulka]

What error are you getting (Invalid use of Null?)
Why can't you just use the same technique (appending an empty string)?

 

[ronis]

I get the error that I can not add a zero length string to the field. When I added the "" to the string it gave me the same error.

 

[froggerIII]

in my code, to get past this, I just insert Null into the database

 

[ronis]

I am so confused. I tried adding the empty string again and I tried str=Null. Is that correct? I must be missing something here...

Thank you for you help.

Roni

[sig][/sig]

 

[Riku]

I have same problem. I also tried str=NULL, but no luck.
F: Riku Tuominen
riku.tuominen@benchmarking.fi