color in field of a report???

[_Bigred]

I have a report based on a query (query pulls from main table which
contains
lookup fields).

I can setup the query and report to give me everything I want except "one"
field has a black fill/background and no matter what I try to adjust it
won't change to white or transparent with black text.
(This particular field on the report is a lookup field in the table it
originates from).

TIA,
_Bigred




I'm protected by SpamBrave
http://www.spambrave.com/

 

[Duane Hookom]

It seems you are finding out about the evils of lookup fields.
http://www.mvps.org/access/lookupfields.htm

Include the table used in the lookup list. I expect your control in the
report is a list box. Change it to a text box and set its control source to
the looked up field from the lookup table.

 

[_Bigred]

It seems you are finding out about the evils of lookup fields.

Thanks for the feedback Duane.. I'm a novice access user (know enough to
think I'm pretty good, until I actually hit these types of issues). I guess
I'm really at a loss for how to actually fix it the proper way!

The field in question (that is black backfill with white text) is ultimately
from a table lookup, because it contains approx. 1400 different choices of
weight values - so it was supposed to be easier to the user (me) to pick the
weight from a list (lookup field).

What is the best way to approach and do you have any good web links or books
that (don't take 4 yrs of college to understand) so I can begin to use
"proper" technique in building my db's???

Thanks much for your help and feedback,
_Bigred

 

[Duane Hookom]

You should use lookup tables to select foreign key values. Don't use these in
tables. Use combo boxes and list boxes in forms. Table views are not for user
interface. Use forms.

Make sure you have a very good understanding of queries (SQL). There are
lots of SQL tutor sites on the web. A good place to find lots of resources is
at Jeff Conrad's page
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html. Make
sure you check out the Ten Commandments, Database Design 101, Naming
Conventions, and Tutorial.

 

[_Bigred]

Thank You Duane, that certainly gives me a good reference point to start
with.

Thanks,
_Bigred