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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top