Input Mask?

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

 

[KARL DEWEY]

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.

 

[Judy]

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.

 

[Judy]

Karl,

It worked perfectly!!! Thank you SO much.

Have a great day and happy holidays!!

 

[fredg]

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.

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.

 

[Judy]

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.

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.

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.