code on Detail format in Access
Posted on 2014-01-22
I have a question that I don't know if it's possible to do. I have a report for users to print out but the report is kind like the memo, I have Text field on the form and I type everything on the text field on the Detail format, I do this is because I have to pull data from the query on this text field, my question is I need to to show ("CCC") but I only can do this as (CCC) without the "" but I need the "", is this possible to do in the detail format of the report? below is the Text field data.
Text133 = "This notice is for Father " & Me.FANAME & " to make Child Cares payments the Child Care Center " & "(CCC)" & "."
The out come of this is
This notice is for Father John Smith to make Child Cares payments the Child Care Center (CCC).
But I need it to be like this
The notice is for father John Smith to make Child Cares payments the Child Care Center ("CCC").