Insert in Table Access without Null

**mutley** · Apr 14th, 2006, 07:28 AM

Hi

How can do Insert in Access Table, without Null,

How can I to remove null before insert in Access Table

**leinad31** · Apr 14th, 2006, 07:31 AM

Depends on the datat type of the field your inserting a value to. Doesn't the table have its default value property set? You won't have to worry about nulls (eg. skipped fields) in the insert statement then.

**mutley** · Apr 14th, 2006, 07:42 AM

Hi

The fields are text value and data field , Whe I trying insert in table return me error

tks

**GaryMazzone** · Apr 14th, 2006, 07:50 AM

What is the error? How is thge datafield defined and on what database system?

**leinad31** · Apr 14th, 2006, 07:51 AM

What's your erroneous SQL query and what's the error message?

**mutley** · Apr 14th, 2006, 08:13 AM

in DataBase is Text format

in VB is textbox

the error is

Field 'TB01.TB01_FONE3' cannot be a zero-length string

**leinad31** · Apr 14th, 2006, 08:16 AM

If you need to accept zero length strings "" for blank entries, then you have to change the property of the field in the database.

Otherwise you'll have to resort to changing the string to " " if its "", in the text box's validate event

**mutley** · Apr 14th, 2006, 08:43 AM

Thank You for all

Thread: Insert in Table Access without Null

Thread Tools

Display

Insert in Table Access without Null

Re: Insert in Table Access without Null

Re: Insert in Table Access without Null

Re: Insert in Table Access without Null

Re: Insert in Table Access without Null

Re: Insert in Table Access without Null

Re: Insert in Table Access without Null

[RESOLVED] Insert in Table Access without Null

Posting Permissions