How can I apply format to an individual Access table or report rec

[Guest]

This would seem to be an easy matter, but I can't find a way to format (e.g.
highlight or change font color) to a single record (row) in an Access table.
The formats instead end up being applied to the entire table. Is there a way
I can format a single record in an Access table? And then have it carry over
into a report made from that table? Or, alternatively, just code the report
so that certain records (rows) will appear with a predetermined format? I'm
using Access 2003. Thanks!

 

[Al Campagna]

Addict,
Not in the tables... but...
You can use conditional formatting in forms to give a specific record a different
format.
In a report, you would use the OnFormat event of the report section to give a specific
record a different format.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

Hi

I would not bother even trying to do the formating in the table.

If you really want to you can use conditional formating on the report fo
specific records if you want (but this would seem a lot of effort).

Something like
ExpressionIs [FieldName]="Wayne"
Then set the format

Hope this helps

 

[John W. Vinson]

This would seem to be an easy matter, but I can't find a way to format (e.g.
highlight or change font color) to a single record (row) in an Access table.

Quite true. You can't.

The formats instead end up being applied to the entire table. Is there a way
I can format a single record in an Access table? And then have it carry over
into a report made from that table? Or, alternatively, just code the report
so that certain records (rows) will appear with a predetermined format? I'm
using Access 2003. Thanks!

You can use "Conditional Formatting" on a report. You'll need some field in
the table which indicates which records are which. When you're working in
report design choose Format... Conditional Formatting from the menu.

John W. Vinson [MVP]

 

[Al Campagna]

John,
Well, I'll be darned... I've developed about 7 or 8 apps (at least) in 2003 and never
noticed Conditional Formatting... in Reports!
When I saw your post, I thought you had typed "report" instead of "form"... by mistake.
I'm still using On Format.... Doh!!
As the old expression goes, "If it had been a snake, it would have bit me! :-D
--
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[John W. Vinson]

Well, I'll be darned... I've developed about 7 or 8 apps (at least) in 2003 and never
noticed Conditional Formatting... in Reports!
When I saw your post, I thought you had typed "report" instead of "form"... by mistake.
I'm still using On Format.... Doh!!
As the old expression goes, "If it had been a snake, it would have bit me! :-D

LOL!

Then I just had a client email me asking if it's possible to have more than 3
conditions in a conditional format. He wants 92. How you'ld EVER interpret 92
colors/color combinations is beyond my ken...

John W. Vinson [MVP]

 

[Guest]

Thanks so much to you, Wayne, and Al, and John for the help with the process
of individual formatting. My report is coming along beautifully with amazing
formatting changes programmed in now that pop up in colors, highlights, etc.
according to the rules set. Getting the report right is the last piece in a
database application I've been creating that should make work a LOT easier
for our office staff. I appreciate your help!

Hi

I would not bother even trying to do the formating in the table.

If you really want to you can use conditional formating on the report fo
specific records if you want (but this would seem a lot of effort).

Something like
ExpressionIs [FieldName]="Wayne"
Then set the format

Hope this helps


--
Wayne
Manchester, England.

This would seem to be an easy matter, but I can't find a way to format (e.g.
highlight or change font color) to a single record (row) in an Access table.
The formats instead end up being applied to the entire table. Is there a way
I can format a single record in an Access table? And then have it carry over
into a report made from that table? Or, alternatively, just code the report
so that certain records (rows) will appear with a predetermined format? I'm
using Access 2003. Thanks!