code on Detail format in Access

Hi Experts,
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").
urjudoAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try this


Text133 = "This notice is for Father  " & Me.FANAME & "  to make Child Cares payments the Child Care Center " & "(" & """CCC""" & ")" & "."
0
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
Try:

Text133 = "This notice is for Father " & Me.FANAME & " to make Child Cares payments the Child Care Center (" & chr$(34) & "CCC" & chr$(34) & ")."

Jim.
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPConnect With a Mentor Commented:
Or this :

Text133 = "This notice is for Father " & Me.FANAME & " to make Child Cares payments the Child Care Center  (""CCC"")."
0
 
urjudoAuthor Commented:
Thanks so much experts!!! I wish I can give each one of you 500 points.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.