Using expression to change font colour on form tab..

[DNolan]

Hello,

I was wondering if anyone could help me. I have an access form with
tabbed pages on it. I would like the colour of the tab name to change
when a user inputs information into the fields on the page, i.e when
they start a new record all the tabbed pages have their name in black
and when they input info into a page the font colour of the page name
turns to red. This is so that they can easily see if any pages have
not been updated.

I have tried using an expression to do this but have hit a brick wall,
I'm not good with VB code so I was trying to just use an expression or
macro using the event procedure when after a field is updated. Would
anyone know how I can do this?

Thanks in advance for any help you can give.

DNolan.

[Tom van Stiphout]

On Mon, 17 Dec 2007 06:32:59 -0800 (PST), DNolan
<da*******@eirc om.netwrote:

There is no way to do that with the standard tab control, unless you
use pictures. Perhaps an alternative would be to change the caption of
a tab after it has been completed: "Page 1 DONE", etc.

-Tom.

>Hello,

I was wondering if anyone could help me. I have an access form with
tabbed pages on it. I would like the colour of the tab name to change
when a user inputs information into the fields on the page, i.e when
they start a new record all the tabbed pages have their name in black
and when they input info into a page the font colour of the page name
turns to red. This is so that they can easily see if any pages have
not been updated.

I have tried using an expression to do this but have hit a brick wall,
I'm not good with VB code so I was trying to just use an expression or
macro using the event procedure when after a field is updated. Would
anyone know how I can do this?

Thanks in advance for any help you can give.

DNolan.

[mdumanic]

You might want to try out this link: http://www.fontstuff.com/access/acctut12.htm

It's a cool thing and it could be useful ;)

Manir

[DNolan]

Many thanks for your replies guys!

The coloured tabbing looks very cool and is something I might use in
the future...

Tom, I was looking at using pictures too...as in when a user fills in
the fields on a tab page an embedded assess picture appears on the
tab, or even when they fill it in the picture is deleted. I could not
get the expression builder to do this, I was trying to use one of the
standard built in pic's that access has when you goto add one onto a
tab..say 'MS Access Form' Is there a way I could do that? Just add
that pic to the tab when the fields are filled in..

Thanks..

D.