Use Table Field Description for Forms 1

[deltaair]

IS there a way to use the table field description for Forms. So that instead of the field name it shows the field description, like say for a survey or something ?

 

[Ed2020]

No, but if you set the caption property of the fields in the table Access will use these as the label captions on bound forms.

Does this do what you want?

Ed Metcalfe.

Please do not feed the trolls.....

 

[TheAceMan1]

How are ya deltaair . . .

Why you want to do this is a mystery, but I guess you have your reasons.

Might I suggest [blue]enumerating thru the textboxes and setting the ControlTipText[/blue]. To accomplish this, add a question mark [purple]?[/purple] to the [blue]Tag[/blue] property of all textboxes of interest. Then in the [blue]Load[/blue] event of the form:

[blue]   Dim ctl As Control

On Error Resume Next
   For Each ctl In Me.Controls
      If ctl.Tag = "?" Then
         ctl.ControlTipText = CurrentDb.TableDefs("TableName").Fields(ctl.Name).Properties("Description")
      End If
   Next
On Error GoTo 0[/blue]

The fields must reside in the same table . . .

See Ya! . . . . . .