Default Value If NULL

[shamas21]

Hi All

Is there an option within access that populates a cell if the user leaves it blank

i.e. if i have three columns in a table that defined as ID, Name, Salary - then lets say the user doesnt fill in salary can i have access assign the cell to £1000 if the cell is left empty?

Thanks

 

[KenHigg]

You can do this at the table design level with the default value property. Would that work?

 

[MSAccessRookie]

When the table is defined, there is an option to define a default value for each column. If you are not setting up a new table. opening the table in Design View, will allow you to set the default value(s) that you need.

 

[MSAccessRookie]

Ken Always beats me with the easy answers. That will work for any future entries, but existing entries without values would need to be updated by hand or by query.

 

[shamas21]

Thank you for your help