non-numeric data in numeric field

  • Thread starter Thread starter rc
  • Start date Start date
R

rc

Is there any way for users to input a character like *
into a Number field as an indication that there are
comments to read associated to that field?
 
rc said:
Is there any way for users to input a character like *
into a Number field as an indication that there are
comments to read associated to that field?

No. The closest you could come, I guess, is use a Text field instead,
with a Validation rule that restricts entry to numbers or numbers
followed by the "*" character. Then, of course you'd have to split out
the numeric part any time you wanted to calculate with it or summarize
it. This is really not a good idea if the Number field is really going
to be used for, well, numeric stuff. Besides, it violates one of the
first principles of relational database design, by storing two pieces of
information in a single field.

Why not just have a separate field to hold this comment indicator?
 
Back
Top