Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    New York, NY USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Column Heading in Subform

    When I display a form in datasheet view, the name of the control shows as a column heading. Because I use the recommended naming conventions, the column heading reads (for example) "txtLastName" or "cboLIstings". Is there any way to make the datasheet column heading more user friendly without changing the name of the control?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Column Heading in Subform

    Are you displaying your datasheet as a stand-alone form/datasheet, or is it a subform displayed on another form?

  3. #3
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Column Heading in Subform

    I've done this setting the caption property in the table design to the desired heading. Then create a columnar form using the wizard and set the form views allowed to datasheet only. Or if you have an existing columnar form modify the label's caption property.

  4. #4
    Lounger
    Join Date
    Jan 2001
    Location
    New York, NY USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Column Heading in Subform

    Thank you. I realize now what I did: To "clean things up," I deleted the labels in the form design view. Now that I have reinserted the necessary label, the datasheet view works exactly as I want. I appreciate your help!

    Joe

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •