Results 1 to 4 of 4
  1. #1
    kattatonic1 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2013
    Location
    Toronto, Canada
    Posts
    77

    Question When are field captions inherited from the source tables?


    I have carefully put captions on all fields in my tables because I use conventional prefixes for fieldnames. E.g., fieldname: strLastName / caption: Last Name. I can't figure out why some queries and some forms inherit them beautifully and why some revert to the fieldnames.

    Hoping it's a simple roll-yer-eyes question for one of you on this fine day!

    Kay from Toronto
    Access 2010

  2. #2
    JeroenMioch's Avatar
    JeroenMioch is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    May 2012
    Location
    Den Haag, Netherlands
    Posts
    368
    My captions never inherit them, strangely.
    I never name them either because they dont do anything for programming use.

    And in the rare case that they do, i use a prefix like you, "cptLastName" for example.
    I would stay clear from the prefix "str" by the way, as that is sometimes used to point to a string, like "strDate" in VBA.

  3. #3
    kattatonic1 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2013
    Location
    Toronto, Canada
    Posts
    77
    I'm not sure I understand what you're saying about your experience, JeroenMioch. Unless your users always see the awkward fieldnames with their prefixes on Forms? Do you mean that you retype every fieldname on every form? I have dozens of forms. That would be a lot of work and maintenance.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    I never set these properties in tables just because they do cause confusion. The worst is to set Lookup in table.

    Expressions must reference the actual field name.

    As for forms/reports and controls, depends how you create them. Wizards should use the caption for associated label. Drag a field from the field list and it should use the caption for associated label.

    I don't use prefixes on field names.

    Retyping? That's what copy/paste is 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.

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

Similar Threads

  1. Inherited 2003 database - need help!
    By turgid.dahlia in forum Database Design
    Replies: 6
    Last Post: 08-01-2013, 08:09 AM
  2. Missing .mdw file for inherited MS Access 2007 DB
    By NewMexicoNovice in forum Security
    Replies: 4
    Last Post: 05-07-2013, 01:55 PM
  3. Replies: 1
    Last Post: 03-17-2012, 08:49 PM
  4. Running a code in an inherited Database
    By jlgray0127 in forum Forms
    Replies: 12
    Last Post: 03-14-2012, 02:58 PM
  5. inherited properties
    By bginhb in forum Access
    Replies: 1
    Last Post: 03-10-2012, 08:42 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