Results 1 to 9 of 9
  1. #1
    jtalbot0001 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2013
    Posts
    20

    Is it possible to add dots / full stops at the end of every line in a report?

    I'm not sure what to call it, dots or full stops, but at the end of every line I would like to try and have dots appearing to a certain point. Can I automaticaly add this in to my report? (please see picture for example of what I am trying to achieve). Thanks.

    Click image for larger version. 

Name:	Dots.jpg 
Views:	17 
Size:	80.2 KB 
ID:	13322

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    In your report's record source where you select which fields to display, add the dots to the field name, such as: FieldWithDots: [fname] & ".........". Put as many dots in as you want, the text box width should stop displaying too many.

  3. #3
    jtalbot0001 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2013
    Posts
    20
    Thanks for the reply. I tried what you said and I get the dots to appear so thanks for that. But now I need to tweak it if possible. The thing is, my text boxes are designed to grow when needed, so I need to be able to tell it to stop at a certain point if my 'description' goes on to a second line but that certain point fluctuates. IE, if you look at the picture above as the example, each line has a different amount of 'description' and then each has a different amount of dots, but yet they are told to stop at a point. Basically I do not know the amount of dots to fill, it should determine that automatically.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Call it padding. This will require a non-proportional font such as Courier. Review: http://support.microsoft.com/kb/210573
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    jtalbot0001 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2013
    Posts
    20
    Hi June7,your idea is interesting and I may have use for it at some point, but I found out that it is referred to as "leader dots" and accidentally came across this small example, http://www.lebans.com/leaderdots.htm and the file you can download from that page is called leaderdots.zip. Now I do not understand code or how to place it in a report, such as mine that you already know about, but I managed to kind of fight with the example and get it to do the dots for my table/query. However, the issue I have now is that when the description is long and goes onto a second line, the first column of prices then disappears. The only thing I can think of is that maybe when it goes on the second line that it 'covers' over the price, as in the price box is sitting behind the text box and therefore disappears? I don't know if you or somebody can tell me how to do the dot idea properly as I think I have the issue because I have messed around with the example and that it now doesn't do what it was meant to do. Here is my modded version (attached) of the example for my table/query. And when you look at my version look at Bahamas SG 171 as an example. Thanks.
    Attached Files Attached Files

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    I looked at Lebans 2-line example, which is the one used in your report, and it doesn't seem to work entirely in his.

    Your report won't even open.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    jtalbot0001 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2013
    Posts
    20
    Hi June7, sorry for the delay in reply. Not sure why the report does not open for you? I downloaded that file of mine from the link and it still worked for me, but then I'm not sure if you are patient enough, IE it takes a very long time to run the report, even the little file here takes a good few seconds to make on my pc. My 36000 odd database file takes about 9-10 minutes to process on my pc, but then I haven't got the greatest either, Core 2 Due 2.66ghz. Somehow the dots work fine for me which is brilliant. Maybe I accidentally changed something that isn't in his original file? But thanks again for your help. Jon.

  8. #8
    jtalbot0001 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2013
    Posts
    20
    PS: Please can this thread be marked as solved. Couldn't quite see an option to mark it. Thanks.

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Marked solved - Thread Tools above the first post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 13
    Last Post: 12-23-2012, 02:09 PM
  2. Force New Line in columned Report
    By gg80 in forum Reports
    Replies: 7
    Last Post: 09-20-2012, 07:00 PM
  3. Replies: 1
    Last Post: 04-14-2012, 01:13 PM
  4. DCount on report - per line
    By justinwright in forum Reports
    Replies: 4
    Last Post: 04-13-2012, 10:38 AM
  5. Replies: 3
    Last Post: 03-24-2006, 08:40 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
  •  
Other Forums: Microsoft Office Forums