Results 1 to 3 of 3
  1. #1
    junestag is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Apr 2014
    Posts
    4

    Question Best way to quickly fill fields DOWN with the same value (a la Excel)

    I'm wondering if there is a way in Access 2013 to - for example - enter a value in a date field and then highlight it and drag it down to populate all the records in the table with that value, as can be done in Excel?



    I know this used to not be possible, and that one had to at the very least copy and paste over and over again in Access to accomplish this. Is that still the case?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,898
    That is still not possible in Access table nor on form.

    This is what UPDATE queries are for.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    junestag is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Apr 2014
    Posts
    4
    Thank you kindly June7!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Fill multiple fields with the same information
    By ben_jamin in forum Access
    Replies: 4
    Last Post: 07-23-2013, 07:24 AM
  2. Replies: 9
    Last Post: 10-29-2011, 12:47 PM
  3. Using a combo box to fill in other fields
    By mccluein in forum Access
    Replies: 1
    Last Post: 03-14-2011, 05:40 PM
  4. How To Fill In Multiple Fields From A Form
    By SamanthaSamuels in forum Access
    Replies: 3
    Last Post: 08-16-2010, 12:13 PM
  5. auto fill certain text fields?
    By darklite in forum Forms
    Replies: 4
    Last Post: 07-12-2010, 02:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums