A97 Tab Forms - Colour Change

[Kahuna]

Hi Folks

I have a search form which I use to enter search details and the form data
itself is saved (so the user can have multiple saved search criteria for
later reuse). This works well without tabs as I colour each field that has
entered search data - so its easy to spot and change if necessary (one early
challenge was that users got incorrect data returned from the search because
their eye couldn't easily pick-out fields that had data in them). But now
the search criteria is greater I need to separate it into logical sections,
and with a tab form added I loose the ability to quickly show the user that
there is some search criteria entered into the 'hidden' tabs.

Ideally I'd like to change the tab colours where there is any entered data,
but I don't think that functionality is available in A97, and I don't really
want to go down the route of creating my own tab pages and colouring those
(ala S. Lebans methods).

Any thoughts on how I might resolve this one?

TIA

Cheers

 

[Kahuna]

Wow - came across a great page to easily create great looking coloured tabs
here:

http://www.fontstuff.com/access/acctut12.htm

But that wasn't quite what I was looking for. However playing with the
images on the tabs I reckon I can add an icon / bmp to each tab that has
data entered on its page and show only text where its not!

So... If I want to make a Picture on a tab not-visible what would be the
code? I am using 'Me![Page1].Picture = ""' to remove the picture - but I
really only want to make it invisible is there a '
Me![Page1].Picture.Visible = False' method (this one returns an Object
Required Error).

Any other thoughts welcome.

 

[Marshall Barton]

I have a search form which I use to enter search details and the form data
itself is saved (so the user can have multiple saved search criteria for
later reuse). This works well without tabs as I colour each field that has
entered search data - so its easy to spot and change if necessary (one early
challenge was that users got incorrect data returned from the search because
their eye couldn't easily pick-out fields that had data in them). But now
the search criteria is greater I need to separate it into logical sections,
and with a tab form added I loose the ability to quickly show the user that
there is some search criteria entered into the 'hidden' tabs.

Ideally I'd like to change the tab colours where there is any entered data,
but I don't think that functionality is available in A97, and I don't really
want to go down the route of creating my own tab pages and colouring those
(ala S. Lebans methods).

Personally, I have no idea, but take a look at
http://www.lebans.com/tabcolors.htm
and see if it helps.