truncate a number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm designing a form where I scan a bar code resulting in x digits but I just
need y digits (to be precise from the front). How would I write the code or
design the field to acheive the same?

I also would like to know formatting of Date field. When I open the form in
view mode, I want it to display current date (short) but should be able to
change it and retain the new entered date.

Pls send me help asap and above all I'm a NOVICE.
Thnx in advance.
 
To get only few chr from the front, you can use the left function with the
number of chr you want

=Left([FieldName],3)

will display 3 chr from the left

=========================
About the date, open the form in design view, select the date field, and
change the field Format Property to short date, and set the default property
of the field to
Date()
 
Back
Top