Re: textbox label

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Alavaz,

Ok, I see what you mean. Well, to follow the same theme, I guess you will really have to try to create or identify some field that will always have data in a saved record. You might set up a field specifically for this purpose, if one doesn't exist already. For example you could have a Yes/No data type field, hidden probably, with code on the form's Before Update event like this...
My.YourYesNoField = -1
.... and then the Cinditional Formatting expression that we have been discussing might be something like this...
[NameOfYourField] Is Not Null Or [YourYesNoField] = -1

--
Steve Schapel, Microsoft Access MVP


alavaz17 wrote:
What if a field is left blank b/c there is no data for that field? For ex, a client # that some of our clients use to reference their accts...but some don't, and I don't what to show "client no" in the entered record.

.

Relevant Pages

  • Re: Round hours to nears quarter or 1/2 hr
    ... Assuming you have a Date/Time data type field, ... Steve Schapel, Microsoft Access MVP ... I have been trying to figure out how to get my query to round the hours to the nearest 1/2 or quarter hr. ...
    (microsoft.public.access.queries)
  • RE: Check for record
    ... Dave Hargis, Microsoft Access MVP ... "Chris" wrote: ... client I get the message; nothing when it does not exist for a client. ...
    (microsoft.public.access.formscoding)
  • RE: Check for record
    ... client I get the message; nothing when it does not exist for a client. ... Dave Hargis, Microsoft Access MVP ... "Chris" wrote: ...
    (microsoft.public.access.formscoding)
  • RE: Search Forms
    ... "Klatuu" wrote: ... Dave Hargis, Microsoft Access MVP ... recognize 'Switchboard' as a vaild field name or expression. ... Does the combo box on the switchboard have a row source based on your Client ...
    (microsoft.public.access.forms)
  • RE: Combo Boxes
    ... Macros are valuable for quick and simple tasks; ... Dave Hargis, Microsoft Access MVP ... If client a is selected in combo box 1 and the appropriate site ref number ... I have created a query that picks the information based upon the selections ...
    (microsoft.public.access.forms)