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

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


missinglinq
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

then

[Grant type] = "Public"

then click on the Bold icon.

Linq ;0)>
Jun 4 '09 #2

NeoPa
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?

Thanks
Clinton
Jun 4 '09 #4

NeoPa
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.