syntax question

[smk23]

Greetings and Happy Holidays!

I would like to programmatically change the ControlSource as follows:

Me.NameDisplay.ControlSource = "= ' Fun Data' " & vbCrLf & _

but I get an error when I add anything beyond my last "
What's the correct syntax?
Thanks for the help!!

 

[fredg]

Greetings and Happy Holidays!

I would like to programmatically change the ControlSource as follows:

Me.NameDisplay.ControlSource = "= ' Fun Data' " & vbCrLf & _

but I get an error when I add anything beyond my last "
What's the correct syntax?
Thanks for the help!!

VbCrLf is a VBA constant, so while you can use it in VBA you cannot
use it in a control's record source expression. You must use chr(13) &
chr(10).

Try it this way:
Me!NameDisplay.ControlSource = "= ' Fun Data' & Chr(13) & Chr(10) & '
Hello'"

 

[Marshall Barton]

I would like to programmatically change the ControlSource as follows:

Me.NameDisplay.ControlSource = "= ' Fun Data' " & vbCrLf & _

but I get an error when I add anything beyond my last "

Try this:

Me.NameDisplay.ControlSource = "='Fun Data" & vbCrLf & "'" &
_