Drew Wutka
DWUTKA at Marlow.com
Sun Mar 29 21:06:15 CDT 2009
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 -----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 5:34 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] An Interesting question The default values are NULL. What he wants is for something to show in that field if the value is null. For example on the Time Sheet there's a text box bound to a field named Action. When the value of the current record is null (new record or not) he wants the box to show "Action". But he doesn't want "Action" to be the value of the field in the record. Just wants to show what amounts to a label on an unlabeled field so that the user has some idea of what goes into that field. And yes, the field already has a tool tip. 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 2:38 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] An Interesting question Well on a new record, it would just be setting the default value. But if a field is null, isn't that a value in and of itself? See if you can follow my logic on this. A default value sets a value in a record automatically, if it is not changed. If it is changed, then the record isn't null, it's whatever the user selects (even if it's blank, that's not null, that's an empty string). So the null values would only be for 'older' records, where the value wasn't selected (and there was no default value). Therefore, the solution would be to simply set a default value (I would recommend it being set in the table definition for that field), and then simply write some code, that would check for nulls in the current recordset (OnCurrent event), that would set any null field to the default value defined in the table def. This would effectively eliminate any null values in the underlying data, as they are viewed in your form. 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 4:23 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] An Interesting question A client writes in to ask: "Can combo boxes and text boxes be configured to display a pre-selected text if the field is null or the record is new. For example, could the fields on the TimeSheet that have no labels have the "labels" show on the combo box or text box until a user enters something for that field? " These are bound combos and text boxes. I can think of a couple kludgey ways to do this - overlays with label text that are visible only if there's nothing in the field would be one. But is there a really good way? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/> 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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com 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.