Results 1 to 4 of 4
  1. #1
    mikeone610 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    39

    Formatting text boxes with aggregate functions within a text box populated with text.

    Sorry that title is a tongue twister.

    I have 3 different text boxes that have aggregate functions as there control source; they sum different fields and display the results in the text boxes. Easy enough. Now here is where things have got tricky I need to place these text boxes within a paragraph of text inside a text box and have it somehow formatted to be the corrected size. So it would look nearly seamless body of text with the 3 Aggregate text boxes inside it. O to throw another wrench into it of course the 3 text boxes change every time the query is changed so the size is not dependable.



    Now I have just been tinkering with it trying to find the sweet spot but it is real hard. Is there anyway to like place these 3 text boxes within a body of text and have it just reformat the spacing each time?

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Concatenate fields with literal text:

    ="Some text " & FieldName & " some more text " & AnotherFieldName
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    mikeone610 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    39
    Hmmm ok. Well I now have 4 different text boxes that produce aggregate info about the query. I would somehow need to merge them all into one to concatenate it that even possible? Here is the 4 different text boxes control source:

    =DCount("Lname","Query")
    =DAvg("AvgAmount","Query")
    =Round(DAvg("CountTotal","Query"),1)
    =DAvg("AmountTotal","Query")

    Edit: Ahhhh I got it never mind thank you! Is there a way to change the color of 1 word in a concatenate?

  4. #4
    alcapps is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    292
    ="count of lname " & me.textboxname & " avg amount " & me.txtboxname & " davg count " & me.txtboxname & " davg amount " & me.txtboxname

    just insert the appropriate txtboxname's

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Conditional Formatting of Text Boxes
    By beribimba in forum Reports
    Replies: 2
    Last Post: 03-09-2012, 05:08 PM
  2. Replies: 15
    Last Post: 04-01-2011, 11:41 AM
  3. Replies: 4
    Last Post: 02-14-2011, 09:11 AM
  4. Replies: 15
    Last Post: 09-18-2010, 01:19 PM
  5. joining text in text boxes
    By jjwilliams73 in forum Forms
    Replies: 1
    Last Post: 08-26-2008, 02:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums