Drew Wutka
DWUTKA at Marlow.com
Mon Mar 30 01:01:41 CDT 2009
LOL, true. But I rarely come up with 'elegant' solutions for problems I find relatively pointless. ;) I hope you understand what I mean. It's a client request, which is money in the pocket, but some client requests just seem too silly to take their money for! ;) In other words, it's very difficult to make the elephant in the living room look elegant! ;) Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Sunday, March 29, 2009 10:11 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] An Interesting question It would probably work. But it's about the same level of elegance (or lack thereof) of the overlay approach (text box overlaying the bound text or combo box made visible or invisible depending on whether there was a non-null value in the bound field). Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Sunday, March 29, 2009 7:06 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] An Interesting question Hmmm, other then the obvious 'Ummm why?' questions <grin>, what about running a little code on the OnCurrent event to 'unbind' each control which is null, and placing a 'default' value into them? Then on the OnFocus event of the controls, rebind them? Not sure if that would work, just an idea..... Drew The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.