I need to color each field individually in the Table. How do I do that? Will
the color transfer over to the queries??
--
Bstruck

Tables and queries do not really allow you to format the results - they are
not really intended to be used directly by your users.

If you explain what you are trying to accomplish, perhaps we can help. The
most obvious solution would be to create a separate field in the table to
store the color you wish and then to use that in your forms and reports, but
that might not really be what you need.

--
Rick B



"BeckyS" <(E-Mail Removed)> wrote in message
news:0E49292F-4B5D-4ADC-88DA-(E-Mail Removed)...
>I need to color each field individually in the Table. How do I do that?
>Will
> the color transfer over to the queries??
> --
> Bstruck

Hi Becky,

I'm afraid you are out of luck for coloring individual cells at the table or
query level. You can use conditional formatting on forms and reports to
achieve this effect.

Conditional Formatting
http://www.access.qbuilt.com/html/co...ormatting.html


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________


"BeckyS" wrote:

> I need to color each field individually in the Table. How do I do that? Will
> the color transfer over to the queries??
> --
> Bstruck

You can't.

In actual fact, though, you should never be working directly with the tables
(or even queries): that's what forms are for. In forms, look at Conditional
Formatting.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"BeckyS" <(E-Mail Removed)> wrote in message
news:0E49292F-4B5D-4ADC-88DA-(E-Mail Removed)...
> I need to color each field individually in the Table. How do I do that?
Will
> the color transfer over to the queries??
> --
> Bstruck

For formatting you have much more scope if you use forms to view/edit tables
and queries rather than raw datasheet view. A form in continuous form view
gives you a grid layout similar to a datasheet, but as well as giving you a
great degree of control over the formatting it also allows you to add command
buttons and unbound controls such as a combo box for selecting navigating to
particular record(s). These can be placed in the form’s header and/or footer
so they remain visible as you move through the rows in the form.

While you can have a form in datasheet view as well as continuous or single
form view, it gives you far less control over the formatting, and is not
something I would ever do myself in a developed application. A continuous
form gives a more professional appearance and allows you to have a consistent
‘look and feel’ for the application. To aid this you can create your own
template form and set this in the Forms/Reports tab of the Options dialogue
available from Tools on the main database menu bar. When you create new
forms (though not with the wizard) these will inherit the properties of your
template form.

You can create a basic form very easily based on a table or query using the
form wizard. This can then be modified to suit your particular requirements.

Ken Sheridan
Stafford, England

"BeckyS" wrote:

> I need to color each field individually in the Table. How do I do that? Will
> the color transfer over to the queries??
> --
> Bstruck

"The most obvious solution would be to create a separate field in the table
to store the color you wish and then to use that in your forms and
reports..."

If one wanted to do this, how would I?

Thanks
Ember

"Rick B" wrote:

> Tables and queries do not really allow you to format the results - they are
> not really intended to be used directly by your users.
>
> If you explain what you are trying to accomplish, perhaps we can help. The
> most obvious solution would be to create a separate field in the table to
> store the color you wish and then to use that in your forms and reports, but
> that might not really be what you need.
>
> --
> Rick B
>
>
>
> "BeckyS" <(E-Mail Removed)> wrote in message
> news:0E49292F-4B5D-4ADC-88DA-(E-Mail Removed)...
> >I need to color each field individually in the Table. How do I do that?
> >Will
> > the color transfer over to the queries??
> > --
> > Bstruck
>
>
>

As Rick said, it would help if you explain what you are trying to
accomplish. Why the colours? What if the user is color-blind?

TC (MVP Access)
http://tc2.atspace.com

This is to create color coded labels for a filing system. Their are nine
"Groups" that the users can use in which to classify their files. On the
folder label will be the group code (ACC) and the color red. This will aid
in locating misfiles easily (for those who are not color blind).

Condition formating only allows you to define three conditions, and as you
see I have nine. I have seen several different approaches to this solution,
but am unable to modify them to fit my situation.

Thanks for the help!

Ember

"TC" wrote:

> As Rick said, it would help if you explain what you are trying to
> accomplish. Why the colours? What if the user is color-blind?
>
> TC (MVP Access)
> http://tc2.atspace.com
>
>