I have a field on a form that is Text 7 characters. The value that must be entered has a pattern of ###.#:1. e.g. 098.3:1.
The right 2 characters will always be ':1' as this is a ratio.
How do I specify the Pattern Matching (on the form and also using VBA in an Event) to ensure that the left 5 characters are always entered and in the specified format of 3 digits a decimal point and one digit with the right two characters always ':1'.