Results 1 to 2 of 2

Thread: Labels in forms

  1. #1
    Join Date
    Nov 2006

    Unanswered: Labels in forms

    I do have a problem with an Access application i dont have developed myself.
    I have a form with several unbound subforms. The datasources in the subforms is ordinarie tables.
    The subforms is wiewed as datasheet.
    Now the problem:
    I cant change the capture on the fields labels. In the tabledesign I have set the titles on the
    fields and when i create a new form i do have the titles as i want to. But, when i
    wiewe the form as datasheet the capture of the labels will be the same as the name of the fields datasource(even if
    I change on the forms too).
    As I said, I have not develope and create this database appl.myself.
    Anyone able to help??



  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    ?? maybe alias the source fields via a query:
    SELECT tblMine.[unwanted ugly field name 12345] AS NiceName FROM ....

    NiceName: [tblMine].[unwanted ugly field name 12345]
    if you are building the query in design view.

    ...and feed the form from the query rather than direct from the table.

    currently using SS 2008R2

Posting Permissions

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