How to show 6 digits of serial number in report?

[Mai Le]

Hello,
I have a table in Microsoft Access with serial numbers field for production, this field contains 10 digits. I would like to show just 6 digits in report, example in table 0000123456 but in report just 123456 . Could you please show me how to do it. I would appriciate for your help.

Thanks

[Dormilich]

that depends on the programming language you use.

(and it would be easier to guess if you had it posted in the appropriate forum—the editors forum is related to writing articles)

[Mai Le]

This is Microft Access.

[missinglinq]

Add an unbound textbox to the form and in its Control Source enter

= Right([YourFieldName], 6)

where YourFieldName is the name of the field holding the data.

Welcome to Bytes!

Linq ;0)>

[Mai Le]

Thanks for your help. I tried but somehow it doesn't work. Here is attachment for review.

Thanks

[missinglinq]

That's because you named your unbound textbox Sn, which is also the name of your field! Rename the textbox txtSn, then be sure that the control source is

=Right([Sn],6)

(Access will probably change it to =Right([txtSn],6) so you may need to take out the txt.)

Linq ;0)>

[Mai Le]

Thanks alot !!!
It's working.
Exellent !!!

[missinglinq]

Glad we could help!

Linq ;0)>