Re: Number AutoCorrect

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"pushrodengine via AccessMonster.com" <u36225@uwe> wrote in
7cba728aa0269@uwe:">news:7cba728aa0269@uwe:

I need an Employee Number text box in the format â??0000â??. The
catch is, users are supposed to enter â??0345â??, but some will
forget to enter the zero â??345â??. How can I get it so that if
the zero is left out an expression will automatically enter it?

Thanks


in the AfterUpdate event of the control, concatenate 4 zeroes and the
entered number, and grab the four rightmost characters.

me.EmNo = right("0000" & me.EmNo,4)
If me.EmNo = "0000" then
msgbox "You forgot to enter an Employee Number"
end if

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

.

Relevant Pages

  • Re: Query re ADO.NET, constraints, relations, and cascading updates/deletes
    ... > and I'm running into problems with record deletions. ... > child records relating to the parent (Employee) record I'm ... > Imagine I have a staff of employees, each with zero or more Phone ... > literature that actively requires enormous training can be at best ...
    (microsoft.public.dotnet.framework.adonet)
  • how to return Comparator values
    ... public class EmpSort { ... public int compare(Employee e1, Employee e2) { ... positive or zero. ...
    (comp.lang.java.help)
  • RE: Complex conditions using SUMIF
    ... Just make sure that all the array sizes withing SUMPRODUCT are the same size. ... I need to analyze employee date and am having problems. ... I need to know the sum of Amount by employment status ONLY if the amount is ... how I can limit it only to amounts greater than zero. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Complex conditions using SUMIF
    ... When competing hypotheses are otherwise equal, ... I need to analyze employee date and am having problems. ... I need to know the sum of Amount by employment status ONLY if the amount is ... how I can limit it only to amounts greater than zero. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Best way to minimize payroll tax
    ... Depending on whether you're an employee or employer: Fire all your ... One can't get lower than ZERO! ...
    (misc.taxes)