Limiting size of entries

[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?

 

[Cheryl Fischer]

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)

 

[Paul S]

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

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?

.