Results 1 to 5 of 5
  1. #1
    darklite is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    41

    auto fill certain text fields?

    Does anyone know of an easy way to set 3 different text fields to automatically fill with the same info? I have an online store database, and would like to have certain postal fees and charges to automatically fill in because they never change. Also, I have a lengthy refund policy that i would also like to fill in automatically.

    I don't know vba at all, so if it's that, I'm done for. Is there anyway to set a default on the table? For example, one field will always say something like $2.95. So, when I add data into the form, I'd like the field to be pre-filled. Is this possible? Thanks!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    As answered elsewhere, you can set a default value at the table level.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    darklite is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    41
    I actually tried that, and nothing happens, the fields still come up empty. In the default value area, do I literally type in the info, or do I have to do something else? Oh yeah, I'm using Access 2010. Does that make the difference?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    My PC with 2010 on it is off right now, but it shouldn't make a difference. Given your example, you would just type into the default value property:

    2.95

    You can also set a default on the textbox on the form.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    darklite is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    41
    Thanks, I finally got it. The only way it would work was to go into the expression builder and type ="2.95". Just typing it into the control source, or default value on the table didn't cut it. Now it works.

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

Similar Threads

  1. Auto fill a field from multiple lookup
    By shahemaan in forum Forms
    Replies: 4
    Last Post: 06-13-2014, 04:00 PM
  2. Replies: 6
    Last Post: 04-14-2010, 11:03 AM
  3. Auto-fill in datasheet
    By Terence in forum Database Design
    Replies: 2
    Last Post: 03-18-2010, 03:42 PM
  4. Auto Fill-In Capability?
    By bbarrene in forum Access
    Replies: 3
    Last Post: 01-15-2010, 08:35 AM
  5. Auto fill a table?
    By newtoAccess in forum Access
    Replies: 3
    Last Post: 11-21-2009, 08:21 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