I have a field in a form that requires the whole thing to be capitals. Is
there any way apart from using an input mask that would allow me to do that?
thanks

I am having a problem with a validation rule that is meant to force users to
enter only upper case in cboDiagnosis which has row source qry_diagnosis.  
The validation rule is
=StrComp(UCase([Diagnosis]),[Diagnosis],0)=0

I want to check if there is no value return...how should I write this line of
code?
strPartNumber = Nz(DLookup("PartNumber", "Kanban", "PartNumber='" & Me.
txtPartNumber & "'"))

In a tab I have 7 date fields named "SLA_Date1" to "SLA_Date7". Next to 6 I
have unbound fields like this:
A
B  C

I'm trying to program the Before Update Event for a text box on my
form.  I seem to be getting thwarted by a system message like, "The
value you entered isn't valid for this field" and leaves the focus
remaining in the text box, with the offending text (or in this case a

I used a command button to open a Form intended for browsing the invoice
status as follows:
Main form:
Supplier Name: ABCD

I am trying to create a small form that has an unbound text box that you
enter a password in. I would like to know how to have the  password appear as
they usually are, when you access a program.  Eg.  the password might be
"payroll" but what appear as you type it in is "******"  ...

Im having main form that is used to add new recors (Data Entry = True) and i
have a subform in this form in wich im showing image. so when somebody inputs
data to main form there is a textbox on which if he will double click it it
will load the picutre in sub form, and its ...

I have an input form using combo, but it could happen the users or other
people hit again the arrow head and choose another choice and the record was
updated wrongly. My question is how can we avoide that people unintentionally
modify the data say " supplier name". I know that ...

I have a form with some text that is a hyperlink to another database.  It
works fine but I get prompted about hyperlinks my be harmfull, etc....
How can I get rid of or now have this show?
Thanks.

Hi all, I know this should be a pretty simple question but I can not
get the answer via forms and the 3 books I have.
I have a table to track my internal invoices so I have the following
fields:

When entering data in a subform, the user can click on the heading of
a field and resize it.  How can I prevent the user from doing this ?
Thanks
Mark

I have a table with the following values: [Store], [SKU], [Desc], [QOH].  I
want a data entry form that my user can select a [Store] once, and then enter
a [SKU] number, return the [Desc] and allow them to edit the [QOH].  Then it
should return to the [SKU] and repeat.  I have ...

I have lurked here for years and gained valuable skills, many thanks.  
However, I have a need to be able to go to the next text box in a data entry
screen when the first text box is full, without having to hit enter.  I saw
the post about doing it with a combo box (Me ...

I am trying to design a form to show the following:A  Unit has 14 outcomes to
be checked at the same 6 times every day.  The outcomes checks can last for
several days.  I have to record whether or not the outcome has been acheived
or not for all checks for however long these last ...