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").
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").
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER