Data in a text box depending on the type of data choosing "text"

[Fred's]

Hi all,

If there a way I can have a something on my form that allow me to
choose which type of data I will
enter into a feild? And whatever the data type entered, the data will
appear on my detail section report.

I'm explaining,

I have form made from a query and that same query came from a table,
and have two feilds names in my table which I will like to choose to
enter one or the other type od data (i.e. Drop ship) or "a time (.i.e.
05:00 PM)

Does anyone have an idea, how this kind of function? can be made.


Thanking you in advance for your continuous free support

Fred's

 

[Douglas J. Steele]

A field in a table can only have one data type.

If you have a need to store differering data types from row to row, it may
indicate a design problem with the table. Your only choice, though, would be
to store the data as text.

 

[Fred's]

A field in a table can only have one data type.

If you have a need to store differering data types from row to row, it may
indicate a design problem with the table. Your only choice, though, would be
to store the data as text.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)












- Show quoted text -

Thank you Doug for your fast response,

Fred's