Feed

  • Thread starter Thread starter anonymous
  • Start date Start date
A

anonymous

I need to feed 0 to the field id if len of the fields less
then 10.
Example: 12345689-0123456789
7891357-0007891357
 
Is the underlying field text or numeric?

If you just want to display this in a text box, then you could use
something like the following, or could use this concept to convert a
textbox entry in the afterupdate event so that if the user entered
'123', it would be converted to '0000000123' immediately after the
user entered the value.

= Right(String(10, "0") & [yourField], 10)

--
HTH

Dale Fye


I need to feed 0 to the field id if len of the fields less
then 10.
Example: 12345689-0123456789
7891357-0007891357
 
If the field is numeric, look into the Format property to display it with
"leading zeros"

Good luck

Jeff Boyce
<Access MVP>
 
Dennis

In design mode, find the Format property, enter something like (actual
syntax may vary):

"0000000000"

Take a look in Access HELP for more on using Formats for display.

(By the way, in your original post, you had some digits, a dash, and more
digits. Where do all those other pieces live? I suspect your question
related only to the digits following the dash, but ...?!)

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top