By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,290 Members | 1,678 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,290 IT Pros & Developers. It's quick & easy.

Formatting in MS Access Reports

P: 7
I have created a report where I have following items
Grant type - text box
SumOfActivity - text box

What I want to do is conditionally format to "Bold" grant type Public (this I can do through the conditional formatting tab

"Field Value is equal to Public"

The issue I have is I am unable to format the SumOf Activity to Bold

It is linked to the Grant Type but I am unable to get the formula right - any help would be great

Jun 4 '09 #1
Share this Question
Share on Google+
5 Replies

Expert 2.5K+
P: 3,532
Your question isn't awfully clear, I'm afraid. Are you saying if Grant type is "Public" you also want SumOfActivity in bold? If so, in Conditional Formatting use

Expression is


[Grant type] = "Public"

then click on the Bold icon.

Linq ;0)>
Jun 4 '09 #2

Expert Mod 15k+
P: 31,707
I'm confident you have the question aright Linq.
Clinton, please let us know if this answer works for you.

Welcome to Bytes!
Jun 4 '09 #3

P: 7
Thanks Linq

I have been able to make GrantType ="Public" bold but my problem is the SumOfActivity field does not bold. The SumOfActivity is linked to GrantType but conditionally formating the GrantType does not make all fields Bold

Any further advice?

Jun 4 '09 #4

Expert Mod 15k+
P: 31,707
Have you set the conditional formatting for [SumOfActivity] as suggested in Linq's post. I cannot see why that would fail for you.
Jun 4 '09 #5

P: 7
Sorry redone - that now works - thanks Linq
Jun 4 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.