Display in Report

[lettyg82]

I have a field named CR, the field size is long integer and the input mask i
have as 00\-00000. In this record i enter the case number of a case which is
something like 09CR12345, this field currently displays as 09-12345, i want
to change this so that in a report it inputs the CR instead of the dash -

can someone help.

 

[Jeff Boyce]

?You have a field of type Long Integer (i.e., whole numbers only), and you
want to store "CR" in it? "CR" isn't a number?!

Why? What will having the CR in there allow you to do?

Why? If it will ALWAYS be CR, why do you need to store it or even see it?

If you HAVE to see it, use a query to concatenate the first two digits, a
"CR" and the remaining digits.

(... and the fact that your so-called number seems to have three parts makes
me wonder if you aren't attempting to stuff three separate facts into a
single field. If so, stop! Store each fact in its own field, then use a
query to concatenate them together for display.)

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.