Set contolsource dynamically with concatenation

[Terri]

I'm setting the control source of a report control dynamically from a form
control on the reports OnOpen event.

Me.TextB.ControlSource = "=Forms!frmreporting!TextB"

I want to add an asterisk to the value returned on the report so that if
Forms!frmreporting!TextB = "ABC" the field on the report would return *ABC.

How can I do this? I'm having problems with the syntax, probably the quotes.

Thanks.

 

[Roger Carlson]

What about this:

Me.TextB.ControlSource = "=""*" & Forms!frmreporting!TextB & """"

Which would actually return ="*ABC"

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Larry Linson]

I'm setting the control source of a report
control dynamically from a form
control on the reports OnOpen event.

Me.TextB.ControlSource = "=Forms!frmreporting!TextB"

I want to add an asterisk to the value returned on the report so that if
Forms!frmreporting!TextB = "ABC" the field on the report would return *ABC.

How can I do this? I'm having problems with
the syntax, probably the quotes.

My guess is that you are having trouble because the Controls aren't
available in the Open Event.

If you have only a few choices, pass the name in the OpenArgs (if you are
using Access 2002 or 2003), include each of the actual field sources as text
boxes with their visible property set to No, and an unbound control into
which to set the value for display.

Then in the Print event of the detail section, put code similar to this:

Me.txtText = "*" & Me("txt" & Me.OpenArgs)

where you replace "txtText" with the name of your unbound control, and name
your invisible controls with "txt" and the name you are passing in OpenArgs.

Larry Linson
Microsoft Access MVP