Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Access 2000 Reporting (SP2)

    I am building a 2 column report with peoples names and extension number. Some people have a direct dial number and no ext. The EXT and DD are 2 different fields. If there is no EXT (blank) I want to move the DD over in the EXT space in the report. Is that possible in Access' reporting interface?

    Also, can I make every other name have a background of gray so it's easier to read? I was going to add a rule underneath each name but it doesn't look so great so I thought a striped effect would be better.

    Thanks

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access 2000 Reporting (SP2)

    Create a textbox on your form, and call it txtPhone. It's controlsource should look something like this:
    =IIf( [Ext]="", [DD],[Ext])

    You will have to modify to =IIf( IsNull(Ext)=True,.....) if Ext is Null and not blank.

    As for alternating row colors, I guess you could do it with some work, but I strongly suspect it would be even more difficult to read. Create textbox (or label will work also, I guess), and give it a light grey background. You will then toggle the backgroundstyle property between normal & transparent in the Detail sections onFormat event like this:
    if txtBackground.backstyle=0 then
    txtbackground.backstyle=1
    else
    txtbackground.backstyle=0
    endif
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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