[AccessD] Empty Field Label

Hewson, Jim JHewson at nciinc.com
Fri Apr 10 12:02:01 CDT 2009


No, it can be any name.

Jim


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, April 10, 2009 11:14 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Empty Field Label

Jim:

In your code there does table1 mean I have to create a table in the
front
end with one record?

Regards,

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hewson, Jim 
Sent: Thursday, April 09, 2009 11:56 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Empty Field Label

Rocky,
If you add "Date Worked" to a union query to populate the combo box.
Set the Default to "Date Worked and then use conditional formatting with
the
default.
Something like:  
SELECT "0" as ID,"Date Worked" as Test
FROM table1
UNION SELECT Table1.ID, Table1.field2
FROM Table1;

Then use conditional formatting when the field value is 0.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, April 09, 2009 1:39 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Empty Field Label

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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
########################################################################
####
####
If you have received this message in error, please contact the sender
immediately and be aware that the use, copying, or dissemination of this
information is prohibited. This email transmission contains information
from
NCI Information Systems, Inc. that may be considered privileged or
confidential and is intended solely for the named recipient.
########################################################################
####
####

--
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
################################################################################
If you have received this message in error, please contact the sender
immediately and be aware that the use, copying, or dissemination of 
this information is prohibited. This email transmission contains 
information from NCI Information Systems, Inc. that may be considered 
privileged or confidential and is intended solely for the named 
recipient.
################################################################################




More information about the AccessD mailing list