Input Mask Options for Computer Processor Speed

[LeadTechIG]

All,



I am wondering if there is a way for me set an input mask to allow me enter a computer processor speed after I test the machine by only typing in the numerals, and having access add the "GHz" suffix. Is that an option, and how would I go about doing that?

Thank you.

[orange]

One approach could be to have a number field in the table named ProcSpeedInGHz. All you would need is your numerals.

[June7]

As orange noted, probably should just store number value and append the GHz suffix by expression in query or textbox. Or if something other than GHz is possible, save the unit into another field.

[NTC]

In the AfterUpdate Event of the field in which you are entering put the code: (am calling it YourFieldName)

Dim Entry as Variant
Entry = Me.YourFieldName
Me.YourFieldName = Entry & " Ghz"

the field type must be text of course....and you replace the YourFieldName with the real name....

the just grabs the value that you entered and holds it momentarily as a temporary variable named 'Entry'...and then appends your Ghz to it and sticks the new string back into the same field.....

[June7]

An input mask can accomplish this and without VBA, like: ###"GHZ";0;_

But if you do use VBA, the variable is not needed.

Me.YourFieldName = Me.YourFieldName & "GHz"