Results 1 to 4 of 4

Thread: New Access Report Question... Formatting

  1. #1

    Thread Starter
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    New Access Report Question... Formatting

    I need to get either way to work...

    I have a report that has an Item field & Item Description
    Item needs to be bold
    Itemd Description not bold..

    Indent the first line of the item description to accomadate(sp?) the item...

    EX:
    VB Code:
    1. [B]Item Number 1 - [/B] Description here and when it wraps to the next line
    2.        Starts about here... then goes....
    3.        and continues her...
    4. [B]Item 2 with a longer descirpiton - [/B] And also this should indent like
    5.        the other one did....

    get it?
    SO right now I tried to Overlap the fields... and have the description field CanGrow.. sorta works.. but adding the indent to the line varies??
    Tried using

    =Space(Len([Item])+15) & [Item_Description]

    but since the field is bold.. and not a fixed font.. just doesnt work!!!


    just not sure how to pull this one off....
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

  2. #2
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: New Access Report Question... Formatting

    What if you made the height of the Item Number label = to the height of the description label?
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  3. #3

    Thread Starter
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: New Access Report Question... Formatting

    height isnt the problem though...
    the description label needs to be indented for the space it overlaps the Item label...

    like this:
    Attached Images Attached Images  
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

  4. #4

    Thread Starter
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: New Access Report Question... Formatting

    here is a better look...

    first line.. no good.. too much space..
    second line not enough
    third.. perfect...

    (dont forget.. most of these will be multi line.. so the second line needs to wrap under the first .. like in the first post. Thats why the boxes need to overlap as show in the second post...)
    Attached Images Attached Images  
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

Posting Permissions

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



Click Here to Expand Forum to Full Width