RE: How do I fill an entire column with a value?

Dear Sophie

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

This seems to be an interesting question. There are few solutions to your query.

If you want only a new record to always display same data then you can go to the design view of that table and enter the value in the Default value box in the field properties section. Please bear in mind that it will not affect the current data in the existing field (Column).

I think the following solution is much more appropriate if you already have many records in a field (Column) and just want to update the entire field with the same data.

TO UPDATE ONE FIELD ONLY THAT IS BLANK:

You must have covered update query in your Intermediate Access course.

Please follow these steps:

1. Create a new query and choose the table from the