• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

TIP: How to fill down in Access tables, queries and forms (1 Viewer)

Status
Not open for further replies.

isladogs

CID VIP
Local time
Today, 20:58
Joined
Jan 14, 2017
Messages
13,951
As is widely known Excel has a very useful autofill feature.

AFAIK much less well known is the Access 'equivalent' which allows you to copy the value from the same field in the previous record to the current record

To do so use the keyboard shortcut Ctrl+' (apostrophe)
This works both to fill an empty field or to replace an existing value
It works in tables, queries & continuous / datasheet forms

Of course you can also do this using copy & paste but that needs more clicks ...

A complete(?) list of keyboard shortcuts can be found here:
https://support.office.com/en-gb/article/keyboard-shortcuts-for-access-70a673e4-4f7b-4300-b8e5-3320fa6606e2
I'd be amazed if anyone here knows & uses all of them ....!
 
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom