Limiting size of entries

  • Thread starter Thread starter Paul S
  • Start date Start date
P

Paul S

We are scanning Fedex way builds and would like to have
the last 16 digits imputted into the field. There are 32
digits in total- any suggestions would be appreciated-
should I be looking at using the Expression Builder and
the "=Right" solution?
 
If you will always want the 16 right-most characters of the Fedex WayBill
No, then the Right() function looks like a pretty solid solution:

=Right([FedexWayBill], 16)
 
Thanks Cheryl- Just 1 more ? do I insert this in the
control source?
-----Original Message-----
If you will always want the 16 right-most characters of the Fedex WayBill
No, then the Right() function looks like a pretty solid solution:

=Right([FedexWayBill], 16)

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Paul S said:
We are scanning Fedex way builds and would like to have
the last 16 digits imputted into the field. There are 32
digits in total- any suggestions would be appreciated-
should I be looking at using the Expression Builder and
the "=Right" solution?
Click to expand...


.
Click to expand...
 
Back
Top