Hi Frends,
I m creating an access to VB6 connectivity Project.
I ahve problem that VB6 Gives not me permition to leave any field NULL so
when i save my record it genrate ERROR 94 That is invalid use of null value

In my project it is not necessary to fill all the fields.
PLEASE give me coading to leave alny field NULL in VB6
:S And yes, I was set all fields Required Value FALSE in ACCESS

PLEASE Send me some IDEA to leave any field null

Recommended Answers

All 2 Replies

kindly post the part of the code that is throwing the error.

Hi,

1) You can set the null value for the field by applying the value as "" or Not applying the value.

2) Check the Property for the Field

a) Required = No
b) Allow Zero Length = Yes


Shailaja:)

Hi Frends,
I m creating an access to VB6 connectivity Project.
I ahve problem that VB6 Gives not me permition to leave any field NULL so
when i save my record it genrate ERROR 94 That is invalid use of null value

In my project it is not necessary to fill all the fields.
PLEASE give me coading to leave alny field NULL in VB6
:S And yes, I was set all fields Required Value FALSE in ACCESS

PLEASE Send me some IDEA to leave any field null

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.