Input Mask?

  • Thread starter Thread starter Judy
  • Start date Start date
J

Judy

I'm trying to figure out if what I would like to do can be accomplished with
an Input Mask, or if it can be accomplished some other way. I have a text
field where the users will input "1 of 4" or "2 of 4," etc. I was hoping to
set up the field so that the word OF was automatically there for them and all
they would have to enter is the first and second numbers. Is this possible?

Thanks for any suggestions/guidance.
 
Use this in the Input Mask field properties in the table.
9" of "9
Just remember that it must be a text field. I think you would be better
off using two fields.
 
Thanks, Karl, I will give it a try.

I thought about using two fields, but I didn't know how I was going to get
the word "of" displayed.
 
Thanks, Karl, I will give it a try.

I thought about using two fields, but I didn't know how I was going to get
the word "of" displayed.
Click to expand...

In your table have 2 fields:
[FirstNum]
[SecondNum]
Most likely they should be Text datatype

Then where ever you need to show them together, on a form or report,
use an unbound control:
=[FirstNum] & " of " & [SecondNum]

Regardless of the number of characters, the horizontal spacing around
the word of will always be correct, i.e. 2 of 4, 12598 of 20000, etc.
 
Thank you for your suggestion, fredg. I've used concatenation in queries and
reports previously, and I guess I just didn't think about using it in a form.
Thanks for reminding me of this feature.

fredg said:
Thanks, Karl, I will give it a try.

I thought about using two fields, but I didn't know how I was going to get
the word "of" displayed.
Click to expand...

In your table have 2 fields:
[FirstNum]
[SecondNum]
Most likely they should be Text datatype

Then where ever you need to show them together, on a form or report,
use an unbound control:
=[FirstNum] & " of " & [SecondNum]

Regardless of the number of characters, the horizontal spacing around
the word of will always be correct, i.e. 2 of 4, 12598 of 20000, etc.
Click to expand...
 
Back
Top