Access 2000 Reporting (SP2)

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote