• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

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").
0
urjudo
Asked:
urjudo
3 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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
 
Rey Obrero (Capricorn1)Commented:
try this


Text133 = "This notice is for Father  " & Me.FANAME & "  to make Child Cares payments the Child Care Center " & "(" & """CCC""" & ")" & "."
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now