Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

how do i fill

Forum home » Delegate support and help forum » Microsoft Access Training and help » How do I fill an entire column with a value?

How do I fill an entire column with a value?

ResolvedVersion 2007

Sophie has attended:
Access Introduction course
Access Intermediate course
Excel Advanced course

How do I fill an entire column with a value?

For example if in a table my column heading is 'Country' and I want all cells that are blank to be filled with United Kingdom how would I do this? Or for example if some of the cells in another column = 'uk' then how could I get all of the cells in the country column to be filled with 'United Kingdom' if the specific cell in the same row had the value UK?

I look forward to your response.

Kind regards,
Sophie Lloyd

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

Access tip:

Remove spaces in a table

If you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.