Expression in Form Caption?

[swbrodie]

Hello.

Is it possible to display an expression in a form or field caption?

I have a form that displays information based on an item (Account #) selected from a combo box. I would like for the form's caption to be set to the Account # that was selected... something like...

="Transactions : " & [AccountName]

Can this be done directly, or do I need to have a macro change the caption or something?

Thanks.

Steve

 

[Graham T]

Steve

In the forms On current event try setting the Forms Caption Property. Something along the following lines:

Private Sub Form_Current()
Form.Caption = "Transactions : " & [AccountName]
End Sub


HTH

Graham

 

[swbrodie]

Thanks

Okay, I thought I would have to change the caption through code.

Thanks for the help.

Steve