Possible to color certain entries? exclude filter? Print options?

[can]

OK, Im new to access, and have a database of 210,000 people.

I have to fit a lot of data printing sideways. Also in a certain format...

First thing...

There is a field that may contain RKS with other info or RKS alone. These must all be red along with the addresses, but thats it. But when I change the font color it changes the whole database. Thats it.

Other thing... I want to do a sort of exclude filter? We need to do some printing... again with the rsk, but we want to exclude anything that has rks in a specific field.

The last thing is print options/page setup...

I want to condense it as much as possible from left to right so al the needed information can be printed.

Here is how we want it printed...

________________________________________________________________
Street here, house # | then other information in approated columns here
customer #, name here |
--------------------------------------------------------------------------

the problem is, street address, house number, customer number, first and last name are all in different columns.

is there anyway i can print it this way?

also the column names need to be extended downwards? some of the names are too long

like |This is column a| but we want

|this is |
|column a|

so it isnt as wide. and I can fit more columns on the page.

Thanks a lot for your help, I only have 2 hours to get this.

Martin Seidl

Oh yeah, if it helps, Im stuck with access in german

 

[ColinEssex]

There is a field that may contain RKS with other info or RKS alone. These must all be red along with the addresses, but thats it. But when I change the font color it changes the whole database. Thats it.

If you have a continuous form you can't do it

Other thing... I want to do a sort of exclude filter? We need to do some printing... again with the rsk, but we want to exclude anything that has rks in a specific field.

Exclude what you don't need in the query grid criteria. (e.g "Not rsk")

The last thing is print options/page setup...

I want to condense it as much as possible from left to right so al the needed information can be printed.

create the report in report wizard, select "fit columns on one page" then go into design view and fine tune it.

also the column names need to be extended downwards? some of the names are too long

In the field properties in the report, check out CanGrow and CanShrink properties.

Col

 

[can]

continuous form? I just have one table with all the columns ... ?

Thanks a lot!

 

[ColinEssex]

You don't mean that you are entering data direct into a table I hope.

You should enter and view data through a form then you can add properties to the form fields (like changing colour etc) but not on a continuous form, only single record forms.

Col

 

[Mile-O]

Urgent? What's the hurry?

 

[can]

well... here is how it broke down.

i recieved a text list that is tab seperated. i simply imported it into access.

the other problem too, is i only have access to access 2003 in german. while i live in germany, my german is pretty bad. making it really hard. i have experience with access... but, not a lot.

 

[can]

urgent, meaning, the " client" needs this right away " he is coming in 1/2 hour.

problem is german language.

 

[can]

uisng the report, i can print out with all the information i need, but it seems like no matter what I do, it will not fit on one page. it always spans two pages.?

yes, I did click on the fit to page.

martin