Solved

code on Detail format in Access

Posted on 2014-01-22
4
358 Views
Last Modified: 2014-01-22
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
Comment
Question by:urjudo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 167 total points
ID: 39800179
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
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 167 total points
ID: 39800183
try this


Text133 = "This notice is for Father  " & Me.FANAME & "  to make Child Cares payments the Child Care Center " & "(" & """CCC""" & ")" & "."
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 166 total points
ID: 39800218
Or this :

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

Author Closing Comment

by:urjudo
ID: 39800231
Thanks so much experts!!! I wish I can give each one of you 500 points.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question