Rocky Smolin
rockysmolin at bchacc.com
Thu Apr 9 13:38:51 CDT 2009
I thought about that but since it's a continuous form it would have to be in the conditional formatting. I couldn't seem to get it to work after fooling with it for a couple of minutes. Again - that old cost/benefit thing. He doesn't want me to spend two hours trying to figure it out. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Thursday, April 09, 2009 11:29 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Empty Field Label Could you have two text boxes for the field and make them visible/invisible depending on content? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Thursday, April 09, 2009 10:18 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Empty Field Label Well, it's a continuous form. SO the format of the record on the continuous would have to change based on the record. I don't think you can do that in a continuous form. I'm also thinking the cost/benefit is not in the client's favor. :) Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Thursday, April 09, 2009 9:28 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Empty Field Label Rocky, sounds like a class to me, and in lieu of that, can't you create a function using an input mask property that you could just call rather than dealing with each individual control? You could use the label's caption as the text, right? Don't know how to help with the combo box problem. Susan H. > Dear List: > > He also wants to extend this technique to text boxes that already have > a format. For example, the 'Date Worked' field has ddd d-mmm-yyyy for > a format. If the field does not have a date he'd like the words 'Date > Worked' > to appear in red. But if I paste @;"Date Worked"[Red] into the format > property it'll override the date format when there's a date in the field. > Any way to finesse that one? -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com