Learn IT

Question of the week of 7/11/11: Quick fill in Access

Question: I my database I would like to fill multiple cells with the same info. In Excel there is that lovely function where you highlight all the cells you want to fill the same info and do a fill right or fill down select and it’s like magic. I am not finding the easy way to do this in Access but there has to be one.

Answer: That feature is not really available in Access, although you can create autonumber fields that will automatically add incremental values. But if you want to fill in a table with repeated values, you must add the field individually or create an update query. You can however, save typing by pressing Ctrl ” to repeat the contents of a field in┬áthe previous record.

Leave a Reply