Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / ActiveX Controls / March 2004

Tip: Looking for answers? Try searching our database.

Command Buttons Frustration

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Melih - 08 Mar 2004 08:41 GMT
Hi

This email is primarily for the folks at Microsoft and us venting our frustration about the poor capabilities of command buttons features.  We have reasearched the Knowledgebase, the MSDN Newsgroups, various web sites, alternative suggestions, etc.  Ultimately, no matter what the results are we found that there is nothing one can do to really change the background color or text control features of command buttons.

The 3rd party options are "ok", but limited - most of them play around with bitmap options that still continue to leave the old command button border (lebans.com) or button painter was another reasonable one, but seemed like a lot work on our part to customize beyond what was there

Additionally, we came across an option that we thought would work well, which was to use ActiveX control buttons.  That fixed our background and text color issue perfectly, but then caused us tremendous havoc in the forms because On Click was no longer available and we had to use the On Enter option - which did nothing but give us errors

No, the fix to this is with Microsoft.  We have spent good money on Developer tools like VS.Net, Office Developers, not to mention countless other licensing fees and we get stuck on what seems to be a simple problem.  I'm sure once a fix is available, we'll have to pay for an upgrade too!

How is it possible that you cannot allow us to modify the background and text color options of command buttons??????  "we don't git this!"  There are enough posting of this problem to warrant a change, don't you think???

Sincerely and pleasantly frustrated!!
Michel Walsh - 08 Mar 2004 11:25 GMT
Hi,

   You should get a better chance to be heard by Microsoft if you post in
their "Contact Us" -suggestion box of their main web page.

   An ActiveX control onClick  should have been exposed, as do the FMS inc.
one (www.fmsinc.com), as far as memory serves.

Hoping it may help,
Vanderghast, Access MVP

> Hi,
>
> This email is primarily for the folks at Microsoft and us venting our frustration about the poor capabilities of command buttons features.  We
have reasearched the Knowledgebase, the MSDN Newsgroups, various web sites,
alternative suggestions, etc.  Ultimately, no matter what the results are we
found that there is nothing one can do to really change the background color
or text control features of command buttons.

> The 3rd party options are "ok", but limited - most of them play around with bitmap options that still continue to leave the old command button
border (lebans.com) or button painter was another reasonable one, but seemed
like a lot work on our part to customize beyond what was there.

> Additionally, we came across an option that we thought would work well, which was to use ActiveX control buttons.  That fixed our background and
text color issue perfectly, but then caused us tremendous havoc in the forms
because On Click was no longer available and we had to use the On Enter
option - which did nothing but give us errors.

> No, the fix to this is with Microsoft.  We have spent good money on Developer tools like VS.Net, Office Developers, not to mention countless
other licensing fees and we get stuck on what seems to be a simple problem.
I'm sure once a fix is available, we'll have to pay for an upgrade too!?

> How is it possible that you cannot allow us to modify the background and text color options of command buttons??????  "we don't git this!"  There are
enough posting of this problem to warrant a change, don't you think????

> Sincerely and pleasantly frustrated!!!
Stephen Lebans - 09 Mar 2004 06:07 GMT
If it bothers you this much you must have come across the solution using
a CommandButton and a Label control.

Set the CommandButton to Transparent.
Place a Label control behind the CommandButton with the desired Caption
and BackColor. Set it's SpecialEffect prop to Flat.
In the CommandButton's MouseDown event set the Label control's
SpecialEffect prop to Sunken.
In the CommandButton's MouseUp event set the Label control's
SpecialEffect prop to Flat.

You could easily write a small bit of code to do this programmatically
for you at runtime.

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

> Hi,
>
> This email is primarily for the folks at Microsoft and us venting our frustration about the poor capabilities of command buttons features.  We
have reasearched the Knowledgebase, the MSDN Newsgroups, various web
sites, alternative suggestions, etc.  Ultimately, no matter what the
results are we found that there is nothing one can do to really change
the background color or text control features of command buttons.

> The 3rd party options are "ok", but limited - most of them play around with bitmap options that still continue to leave the old command button
border (lebans.com) or button painter was another reasonable one, but
seemed like a lot work on our part to customize beyond what was there.

> Additionally, we came across an option that we thought would work well, which was to use ActiveX control buttons.  That fixed our
background and text color issue perfectly, but then caused us tremendous
havoc in the forms because On Click was no longer available and we had
to use the On Enter option - which did nothing but give us errors.

> No, the fix to this is with Microsoft.  We have spent good money on Developer tools like VS.Net, Office Developers, not to mention countless
other licensing fees and we get stuck on what seems to be a simple
problem.  I'm sure once a fix is available, we'll have to pay for an
upgrade too!?

> How is it possible that you cannot allow us to modify the background and text color options of command buttons??????  "we don't git this!"
There are enough posting of this problem to warrant a change, don't you
think????

> Sincerely and pleasantly frustrated!!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.