Results 1 to 4 of 4
  1. #1
    jmunderpar is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2014
    Posts
    2

    Split Form Column Headings (Names) in Access 2010

    Is there a way of changing the column heading names on the split form portion of an access form. I tried changing them using a query to populate the form and changing the caption of each field in the query and that didn't work. I also tried adding a [Caption] at the design level of the table and that had no affect also. The split form seems to be displaying a portion of the actual field name or something like that. I just wasted a couple hours trying to do this to no avail. Please help. Thank you...

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    The headings will show whatever the associated label Caption property is. The label must be associated with the control.
    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
    jmunderpar is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2014
    Posts
    2
    Thank you for that information, but I had already looked at that and it didn't work. Your response forced me to look at it again and I discovered that I had edited many of the labels on the objects on this form and my changing the labels on the screen actually changed the label property. Something so simple drove me crazy for a couple hours. Thanks again...

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    This is solved?
    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. Replies: 1
    Last Post: 11-12-2013, 02:19 AM
  2. Column Headings - Change before uploading to Access Table
    By smoothlarryhughes in forum Import/Export Data
    Replies: 5
    Last Post: 11-08-2012, 12:33 PM
  3. Can Access Column Have Label & Underlying Names?
    By Soule in forum Import/Export Data
    Replies: 1
    Last Post: 12-22-2011, 01:18 PM
  4. Query Entity Names, and Column Names
    By Accidental DBA in forum Queries
    Replies: 1
    Last Post: 07-22-2011, 02:38 PM
  5. Replies: 5
    Last Post: 04-24-2011, 03:14 AM

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