An Alternative to blank or N/A fields

  • Thread starter Thread starter David
  • Start date Start date
D

David

I'm looking for any suggestions of something that users
can input into a numerical field that does not need any
data, i.e an alternative to N/A or 0? Its useful to see if
a field has been missed or is just not applicable for that
record.
 
If the field only accepts numeric, then its either blank or zero. Since I
don't know much about the data, its hard to tell if a negative number
provides any value or not.

One quick thought: Create a hidden field (Yes/No, for sake of discussion,
call it 'IsEntered').
In the Change event of the numerical field, set IsEntered = True. When the
record is saved, you can then check the IsEntered field to determine if the
user has actually touched the record or not.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top