Formatting Formula

[parthoza]

I have a table database with various fields. I have 2 different classes that I want to keep track of and there are multiple sessions in each class. Example: I have Class A and Class B and each have Sessions 1 through 10. I am attempting to automate my table where if I enter A1, the field automatically formats to read "A - Session 1" or if I enter B10, the field automatically reads "B - Session 10". In the design view, I currently have this field formatted as a Short Text Data Type. I have tried 2 different Format types that each partially give me what I want.

• Format Type 1: @" - Session "@@ When I enter B10, the Output is what I am looking for "B - Session 10" BUT when I enter a single digit session, say B9, I get " - Session 9" without the initial "B" in front of the dash.
• Format Type 2: @" - Session "@ When I enter B10, the Output turns into B1 - Session 0 BUT when I enter a single digit session, say B9, I get "B - Session 9" which is what I am looking for.

It appears that when the sessions go into double digits, the formatting gets messed up. Anyone have any suggestions for the correct format I need to use so it works for single and double digit sessions?

[ranman256]

your class needs another field, [caption] to show when you select B10. Formatting not needed.

[John_G]

You only need one format.

Set the format to "!@ - Session @@", and it works fine. When you use "@", the places are filled from right to left by default; using the "!" in front causes the places to be filled from left to right, which is the way you want it.

[parthoza]

You only need one format.

Set the format to "!@ - Session @@", and it works fine. When you use "@", the places are filled from right to left by default; using the "!" in front causes the places to be filled from left to right, which is the way you want it.

Thanks John!