Hey, you have a great idea there. Although my problem was the little tabs sticking out like sore thumbs as you mentioned, using
other controls to go to the various tabs with the actual tabs hidden sounds like it might just solve my problem and allow me to give
the UI a different look. As an aside, I checked my beta copy of Office 2K7 to see if they have offered anything better in the new
version. I am VERY disappointed to see that nothing appears different in the VBA options and capabilities that I've seen so far with
regard to having a more advanced look and more streamlined operation. Sometimes I feel like the new version is similar to opening a
pretty new package under the Xmas tree and then after you open it up, you find that it is the same pair of skates you got 8 years
ago with different shoestrings and maybe a sharpened blade and a flashing led light. Once you get to the options and customization,
both in the main program and in the VBA, it looks like the old skates...exactly like them....no new shoestrings or flashing lights.
Get past the few main changes they made to the apps and it still seems like the same old car. Don't get me wrong, they needed the
rows and columns and memory adjustments. A lot of the rest of it is just minor fluff...IMHO.
Thanks again for your idea. That is a good one and I'm going to try it.

Signature
RMC,CPA
Hi R.Choate
The only way around this that I'm aware of is to create an image in some
other program using 2006 Mazda Gradient Cool Blue, and place it in the
'body' part of the tab strip to cover up the 1995 Honda Accord Grey. Use
Format > Order to push it behind the controls.
That will leave the little tabs themselves sticking out like a sore thumb,
but may be enough to bring your form into the 21st century. To get rid of
the little tabs, change their orientation, re-size the form to hide them,
and provide your own Next and Previous buttons to allow the user to
navigate.
Hope this helps.
Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
> Hi folks,
>
[quoted text clipped - 9 lines]
>
> Thanks !
Doug Robbins - Word MVP - 05 Oct 2006 04:50 GMT
Eye-candy is what it's called.
An alternative is to use Access for your data entry.

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
> Hey, you have a great idea there. Although my problem was the little tabs
> sticking out like sore thumbs as you mentioned, using
[quoted text clipped - 51 lines]
>>
>> Thanks !
R. Choate - 07 Oct 2006 15:48 GMT
I think it would be nice to use the advantages of Access forms for several reasons, but this is not "data entry" and taking it to
that level to bypass the restrictions I described is beyond the scope of the project. I'm really primarily trying to make the form
more streamlined and a bit simpler. Going the Access route would do the opposite so I can't really use that suggestion. Just the
same, I appreciate the idea and I will be doing that when I have more of a free pass to do what I want.
You know, since you are an MVP, I would like to know your opinion of MS not offering more "eye-candy" options in the new Office2K7 ?
The new version VBA setup looks and acts exactly like the old version. Aren't they overselling what they did a little bit? Don't you
think that when you get past the added rows and columns in Excel, some changes in memory allocation, and some of the fancy new UI,
it starts to look just like all of the old versions going all the way back to Office97?
Thx,
Richard

Signature
RMC,CPA
Eye-candy is what it's called.
An alternative is to use Access for your data entry.

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
> Hey, you have a great idea there. Although my problem was the little tabs
> sticking out like sore thumbs as you mentioned, using
[quoted text clipped - 53 lines]
>>
>> Thanks !