By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,089 Members | 1,964 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,089 IT Pros & Developers. It's quick & easy.

Using expression to change font colour on form tab..

P: n/a
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.
Dec 17 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Mon, 17 Dec 2007 06:32:59 -0800 (PST), DNolan
<da*******@eircom.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.
Dec 17 '07 #2

P: n/a
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
Dec 17 '07 #3

P: n/a
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.
Dec 17 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.