The Color Palette and Dynamic use in VBA code.

[casinc815]

I have a Form that retrieves a Students reading and language scores from a testing
facility that the local school district uses to monitor the progress of students.

The form is a light blue (sky blue!) and can be found on the last row of the color
pallete in the middle of the pallette. The controls are a light grey and the fields are
sunken white, the fond is black. I have gotten a lot of compliments on the visual ease of the form
and now the user wants me to print the form. I did! I use the Printout function


and the form printed perfectly. Since each student has two result records, each
record was printed perfectly using the Print all function, on one page. Perfect!!!

The problem is not the form or the printing but the color. Now I am told the school went
through two blue cartridges in three days and everyone enjoys printing the colored form.
The head honcho wants WHITE, not BLUE. So FormHeader.BackColor= vbWhite and Detail.BackColor
= vbWhite did the trick and reduced the blue color being printed.

Now what is the color to reverse back to the original color. vbBlue is not the right color.
QBFunction(9) does not change to a sky blue color. The color on the last line of the color pallette
is what I am trying to get to be reproduced. Anybody?

Help! - Jim

[June7]

Better to print a report instead of form.

Try RGB color codes:

FormHeader.BackColor=RGB(0, 183, 239)

Also, review http://blogs.office.com/b/microsoft-...m-in-code.aspx

[casinc815]

Better to print a report instead of form.

Try RGB color codes:

FormHeader.BackColor=RGB(0, 183, 239)

Also, review http://blogs.office.com/b/microsoft-...m-in-code.aspx

Thanks for the help! I will look into this. - Jim

[casinc815]

Thanks for the help! I will look into this. - Jim

I did some review of the suggestion that were made to my inquiry.

As a standard of practice, when I use color it is necessary to get the RGB code so that dynamic
manipulation of color is easier. The code is retrieved from the color pallete under "More colors"
and is then documented in the OnOpen procedure for all forms. The same technique is used on all
field or control within a form.

Thanks for the help everyone.

Jim