truncate a number

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.
 
G

Guest

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()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top