Field Format

  • Thread starter Thread starter DP
  • Start date Start date
D

DP

Hi all -

I have recently redesigned a database that I inherited.
There is a particular field that has to display as 4
digits, with leading 0s. If I set the field as Long
Integer and set Format as 0000, I can get it to work and
display correctly BUT - when the user wants to type in
part of a number, it puts the 0s at the end.

Example:
Item number is 0001
User tries to type in just "1", and the result is 1000.

Suggestions?
Thanks - DP
 
In Tools|Options, select the Keyboard tab and try setting "Behaviour
entering field" to "Go to end of field"


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Thanks, I tried that. It didn't work....DP
-----Original Message-----
In Tools|Options, select the Keyboard tab and try setting "Behaviour
entering field" to "Go to end of field"


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control



.
Click to expand...
 
Are you doing this in a form, or directly in the table ? Personally I dont
set formats on data entry forms, it seems to cause more trouble than its
worth. By all means, format reports and display forms any way you want, but
leave the data entry unformatted.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top