Conditional Formatting (reports) (2003)

Topic

New Reply

Is there a way to control the font size, weight and number of decimal places of controls on different rows of a report, so that different rows use different settings? I have been asked to produce a report which is sort of rotated through 90 degrees from the usual format that Access caters for. The report is for a retail company and will have one column for each of their stores. The rows will then (usually) come in threes:

Performance this year
Performance Last Year
Percentage Change

I have managed to rotate the data so that it fits this requirement, but I

Reply | Quote

Replies

You can use the Detail_Format event to format controls specifically for each record.

Reply | Quote

Of course! (sound of head being slapped)
Thanks again.

BTW, I didn’t get an email to rell me that this reply had been posted. Have I changed a setting somewhere?

Reply | Quote

If the problem with no e-mail notifications persists, you can post a question in the Lounge Matters forum.

Reply | Quote

I have had that problem too – it was down to an overly helpful ISP who thought that emails which are addressed to myself (which is what seems to happen with the messages from here) were trash and so held them in my trash folder.

Reply | Quote

I’ve just received the three replies to the origanal post this morning.
Has something happened at Woody’s Lounge? I will contact my ISP anyway.

Reply | Quote

I’m not aware of something out of the ordinary in the Lounge, so I guess it’s your ISP.

Reply | Quote