dear friends ,
i have an field name for Eg ,[ train detention] ..(date/time)
if the train detained entry will be (date and tme )
else (text) like "not
stoped" ,,etc
how to format a field text box for this and further use the
time
value foir calulation
balu.
The textbox on the form *IS NOT RELEVANT*. What's important is the datatype of
the field in the table; the form and the textbox on the form are only tools to
edit the data in the table.
If you are using a Date/Time field in the table then you *CANNOT* store text
in it - only dates and times. The field is actually stored as a Number, a
count of days and fractions of a day from midnight, December 30, 1899. As such
you cannot store "not stopped" into the field.
You can store both date data and text data in a Text field, but this is
probably not a good idea, since text dates will not sort correctly nor can
they be easily searched by date range.
I would suggest using TWO fields in your table - one for the date and time,
and a second field for comments. The date/time field could be left NULL and
the text field used for an explanation; or you could provide comments or
explanation even if there is a date/time value in the other field.
John W. Vinson [MVP]
