how to set up a line that change colors by entry with "Access"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to set up a proccess training with pictures using Access and I want to
be able to set the color of a line by puting some information or clicking
some where
 
You would have to be much more specific. A line where? In a table? On a
report? What colors? What condition? What version of Outlook? You will
most likely want to use the conditional formatting. Check the help file, or
post back a specific question that we can answer.

Rick B
 
See the Properties under the Format tab for means of controlling the
appearance of lines. The color is controlled by the BorderColor property.
To set a line named Line5 to Red, for example, the VBA code is:

Me!Line5.BorderColor = 255

For other colors, simply set this property manually by either picking one of
the predefined colors or using the wizard and see what code Access inserts
into the property.

Hope that helps.
Sprinks
 
Back
Top