Adding Empty Textbox to table (1 Viewer)

D

durdle

Registered User.

Local time

Today, 07:00

Joined

May 7, 2002

Messages

130

• Jul 2, 2004

• #1

Hello,

I am using a SQL statement to add a record to a table. But when I leaving one field blank it will not add this record. I don't want to restrict the user from not putting anything in the textbox. Do anyone know a way around this?

Thanks
________
list of subaru transmissions

 

Last edited: Feb 10, 2011

W

WayneRyan

AWF VIP

Local time

Today, 07:00

Joined

Nov 19, 2002

Messages

7,122

• Jul 2, 2004

• #2

Durdle,

Get the table in Design View and (for that field), set Required = No.
Otherwise, it won't accept entries.

Wayne

 

D

durdle

Registered User.

Local time

Today, 07:00

Joined

May 7, 2002

Messages

130

• Jul 2, 2004

• #3

Wayne,

I checked that and it was already set to No.
Any other ideas?

durdle
________
hz engine

 

Last edited: Feb 10, 2011

KenHigg

Registered User

Local time

Today, 02:00

Joined

Jun 9, 2004

Messages

13,327

• Jul 2, 2004

• #4

Would you have to compensate for nulls?

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Today, 02:00

Joined

Feb 19, 2002

Messages

43,223

• Jul 2, 2004

• #5

You probably also need to set "AllowZeroLengthStrings" to yes.