Question for Stephan Lebans..or anyone who can help.

[DNolan]

Hello,

Basically I have a form with 7 tabs on it, I have been trying to
change the tab font colour when a user enters information on a tab so
that at a glance they can see what tabs have been updated. I realise
this cannot be done so I have been looking at Stephan Lebans tab
colour change code with the thought of changing the tab heading colour
after the information on the tab has been updated. This would mean the
tab heading would permantley change colour once updated but the main
tab window would stay the same default colour.

As I'm not great at coding I have come to a brick wall, would it be
possible to use the tabcolor code to do this? And if so could anyone
help me on how to do it?

Thanks in advance for any help you can give me on this.

DNolan.

 

[mscertified]

Why not just change the tab caption, say to place an asterisk at the end when
the tab has been processed?
Much simpler than messing with colors.
If you try to take advantage of unsupported code, it may fail to work in
newer versions of ASccess.

-Dorian

 

[Stephen Lebans]

You do not need to use my TabColors class. There are several solutions to
your issue. Here is a simple one.
1) Create a duplicate Tab control(Tab2). Set its Visible prop to No.
2) For each individual Page of the Tab2 control, load a BMP image you create
containing the desired color and text into the Page's Picture property.
3) When you want to change the color/text of a Page on your Tab1 control
simply copy the PictureData property of the relevant Page of Tab2 to the
PictureData prop of the matching Page of Tab1 control.

Access 2007 has changed how it exposes the Image data of embedded images.
You might have to forgo embedded images and simply use the Picture property
of the Page to load the desired BMP's directly at runtime.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[DNolan]

Hi Guys,

Thanks for your replies. You know, the tab page caption change would
do the job really. The thing is if I change the tab page caption after
a field has been updated on that page, this will apply to all
records..wont it? That is, I create a new record, enter in new data on
the tab page, then the caption changes..wont this stay changed for all
records?

I tried using the expression builder to change the tab page caption
after updating a field, it didnt seem to work, my expression is
=tabpagename.Caption="newcaption" wont work for some reason.

Maybe you could help me out with the above.

Thanks!

DNolan