Concatenate Variables

J

John

Is there a way to concatenate a variable as part of a form caption.

eg.
me.caption=forms.frmPat.txtname & variablename

Please help
Thanks
 
N

Newbie

yes

strName = "This is a variable"
Me.Caption = Forms!frmVar!txtVar.Value & " " & strName

This assumes that frmVar is a separate form in which a value is entered

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables. 0
Use Value of Dynamically Created Variable 5
scrolling form caption 0
Calculation Based on Dynamic Variables (What-if Scenario) 0
Set value for function through form code 3
Repeated phrases wildcard? 1
Are there functions/Or Events that are called automatically whenthe database file first opens and Wh 2
VBA word change keys 0

Top