autofilling ranges columns

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Autofilling ranges in columns

Autofilling ranges in columns

resolvedResolved · Low Priority · Version Standard

Autofilling ranges in columns

Is it possible to autofil a column with a range of numbers - as is possible in Excel for example.

RE: Autofilling ranges in columns

Hi Sarah, Thank you for the post, In answer to your question, to my knowledge this is not possible in Access, however if you wish to enter the same value or text that is in the field above in the same column there is a shortcut keyboard combination of CTRL+' (apostrophe) that will do this. I hope that helps a bit, best regards Pete.


 

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips


Server loaded in 0.09 secs.