Results 1 to 2 of 2
Thread: Access 2000 Reporting (SP2)
2001-07-03, 14:47 #1
- Join Date
- Jan 2001
- 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.
2001-07-03, 15:32 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- 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