how to allow input Alphabet in numeric field ? (1 Viewer)

Mark1982

Registered User.
Local time
Today, 20:23
Joined
Jul 12, 2018
Messages
37
how to allow input Alphabet in numeric field ?
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 10:23
Joined
Aug 30, 2003
Messages
36,118
You can't. A numeric data type can't hold a letter. How would it do math on it?
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 12:23
Joined
Feb 28, 2001
Messages
26,999
The only way to input alphabetic text is to have a string field. Though TECHNICALLY, if the input is to a text box on an unbound control then it can be any character you want as long as you don't specify an input mask.

As Paul states, if you are inputting to a numeric FIELD then you are stuck to a very few cases. You can input the letter E, a decimal point (period), and plus or minus signs if your field is SINGLE or DOUBLE (which are, indeed, numeric formats). You would do that to input numbers in scientific notation: snnnnnn.nnnnnEsnn But otherwise? If it is bound to a table, YOU are bound to the rules of the field.
 

Users who are viewing this thread

Top Bottom