0

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

3
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by manoshailu
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.