Results 1 to 4 of 4
  1. 06-07-2012, 10:28 AM #1
    mcrow
    mcrow is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    2

    Control within Static Text

    Hi, I am very new to access. I am creating a report and would like to insert table data into a paragraph on the report. For example, [SalesContact] of [SalesCompany] has nominated you to receive a free... any help would be great
    Reply With Quote Reply With Quote
  2. 06-07-2012, 10:31 AM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Try a control source of

    =[SalesContact] & " of " & [SalesCompany] & " has nominated you to receive a free..."
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  3. 06-07-2012, 10:39 AM #3
    mcrow
    mcrow is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    2
    Perfect, thank you very much
    Reply With Quote Reply With Quote
  4. 06-07-2012, 10:41 AM #4
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    No problem, and welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Text control to act like combo control
    By chris.williams in forum Programming
    Replies: 2
    Last Post: 11-11-2011, 10:12 PM
  2. IIF statement in control source of text box
    By LilMissAttack in forum Reports
    Replies: 11
    Last Post: 08-18-2011, 10:02 PM
  3. Are reports static?
    By Buakaw in forum Reports
    Replies: 3
    Last Post: 03-22-2011, 10:24 AM
  4. Is it possible to use fields from a table as static text in a form?
    By thekruser in forum Forms
    Replies: 1
    Last Post: 08-31-2010, 03:49 PM
  5. Control Source for Text Box (#error)
    By km8415 in forum Forms
    Replies: 3
    Last Post: 06-27-2010, 10:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums