Put "Nul"l Values in DataRecords

[xerife007]

Hi, Forum

I´m try to put "null" values in the record of access2000 tables to input values later.
To input values by the form i use textbox and maskedbox(in date format).

Best Regards to all,
PJM

 

[Terpsfan]

Are you saying you want to have null values in the table before you enter records or as you enter records? And what field data types are in the table you want to add null values to?

 

[xerife007]

Hi, omega36

Yes i want to insert before enter values and the fields data type are date/time,text,number.

thank you
pjm

 

[Terpsfan]

You could specify a default value of Null in a table column by simply giving it = NULL in the field properties or run an update query that makes specified columns null before you enter data.

Update tablename
SET field = NULL
WHERE condition

 

[xerife007]

It can be for all recorset that i set and the field by field?
My question is becose i use conn.execute""

I have some tables and records that i can put values now wen i open a new record or after i want to continue puting values in the same field.

You aunderstand my idea

Thanks
PJM