color column in datasheet view

F

freckles

I'm using Access 2007. I have a query that I print from datasheet view. I
need to draw attention to a specific column. When I try to change the
background color of just that column or change the font color of just that
column - it always changes the color of the whole data sheet. Is there a way
to change the background color or the font color of 1 specific column in data
sheet view. Thanks for any help you can give.
 
M

Marshall Barton

freckles said:
I'm using Access 2007. I have a query that I print from datasheet view. I
need to draw attention to a specific column. When I try to change the
background color of just that column or change the font color of just that
column - it always changes the color of the whole data sheet. Is there a way
to change the background color or the font color of 1 specific column in data
sheet view.

If you need fancy formatting, use a report.

All you can do in a quey's datasheet is specify a custom
format property. For a text field you could use something
like [Red]@
 
F

freckles

How do you change the text field in just one column to red? When I try to
change the text field - it changes the whole data sheet.
--
needs your help!


Marshall Barton said:
freckles said:
I'm using Access 2007. I have a query that I print from datasheet view. I
need to draw attention to a specific column. When I try to change the
background color of just that column or change the font color of just that
column - it always changes the color of the whole data sheet. Is there a way
to change the background color or the font color of 1 specific column in data
sheet view.

If you need fancy formatting, use a report.

All you can do in a quey's datasheet is specify a custom
format property. For a text field you could use something
like [Red]@
 
R

Ron2006

Are you trying to change the color of a column of data - by that I
mean one field on ALL records (like formating the entire column in a
spreadsheet.)?

OR

Are you trying to change a single field on one record and not ALL the
records?

I have not done much on reports but on forms there is a "Conditional
Format" piece of logic that can be applied. (right click and choise
conditional format on Just that field and specify the logic behind it.

Ron
 
M

Marshall Barton

freckles said:
How do you change the text field in just one column to red? When I try to
change the text field - it changes the whole data sheet.


Use the column's Format property as I said.
 
F

freckles

I'm trying to change the entire column to a different color either background
or font. I finally figured out how to do it in reports but what I really
wanted to do was change one column of the the data sheet. The previous
person who answered my request said to use [Red]@. I tried that and it
worked on text fields but not number fields. Any help you can give me will
be greatly appreciated.
 
M

Marshall Barton

freckles said:
I'm trying to change the entire column to a different color either background
or font. I finally figured out how to do it in reports but what I really
wanted to do was change one column of the the data sheet. The previous
person who answered my request said to use [Red]@. I tried that and it
worked on text fields but not number fields.

The @ doemat code is just for text fields. You would need
to determine the format codes for how you want the numbers
to look and then put the [Red] in that format. For example,
to format integers use [Red]0 or [Red]#, for currency
valuers use something like
[Red]$#,##0.00;[[Red]($#,##0.00);[Red]0.00
 
O

OCTTAR

Perhaps, you can use the conditional formatting but to use this option you
must working into a form, put in design view your form and select the field
that you want to change the background or the text,go to the sub menu (right
click your mouse) and select conditional formatting ,you can add the changes
that you want in Default
formatting option, the effect is that your column shows the background and
the text as you formatted,

OCTTAR
 
E

Evi

Don't be a lazy-bones, freckles, create a report based on the query and
print that :)
Unfortunately (unless Acc2007 is different), even a datasheet form won't
allow much formatting but if you only need the colour when you print then a
report is the way to go.
Evi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top