Please help me with a Articel database

[Bergh]

Hi I have a small problem. I shall create a database for articles.
It should contain these things:
1. Article number


2. From address
3. To address
4. Address from 2
5. To address 2
6. Number in box
7. Number in line
8. Number of the shop
These shall be printed in different colours. The colour must be determined by to address 2, and we should be able to amend these colours how you want.

[maximus]

The best way to do is ForeColor. You have not sepecified whether you want to print a form or a report anyways try this out

in Form or Report load property event type the following VB code.

(assuming you have the following fields in your report or form.

if Me.address 2 = condition1 then
Me.Article number.foreColor="Red"
Me.From address.foreColor="Blue"
Me.To address.foreColor="Green"
Elseif Me.address 2= condition2 then
Repeat the code
End if
End sub

What happens is that the data in the fields are printed in the color that you have specified. But to use this you will have to specify all the color patterns before hand.

if any more help required my email silverback_bats@yahoo.co.in

[maximus]

I am just curious whether you were able to solve your problem if yes please mark this thread as to be solved.
thanx