By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,223 Members | 1,633 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,223 IT Pros & Developers. It's quick & easy.

How to show 6 digits of serial number in report?

P: 19
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
Jul 23 '09 #1
Share this Question
Share on Google+
7 Replies


Dormilich
Expert Mod 5K+
P: 8,639
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)
Jul 23 '09 #2

P: 19
This is Microft Access.
Jul 23 '09 #3

missinglinq
Expert 2.5K+
P: 3,532
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)>
Jul 23 '09 #4

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

Thanks
Attached Files
File Type: zip 6digits.zip (13.3 KB, 82 views)
Jul 23 '09 #5

missinglinq
Expert 2.5K+
P: 3,532
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)>
Jul 23 '09 #6

P: 19
Thanks alot !!!
It's working.
Exellent !!!
Jul 23 '09 #7

missinglinq
Expert 2.5K+
P: 3,532
Glad we could help!

Linq ;0)>
Jul 24 '09 #8

Post your reply

Sign in to post your reply or Sign up for a free account.