setting data type and properties

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set properties if I want to input data that is in feet and inches?
 
Terry

I'm not aware of a "feet & inches" data type in Access.

You'll probably need to use either two number-type fields ("feet",
"inches"), or one text-type field (and then create procedures to parse &
calculate).

Two fields is a bit more awkward for users (they have to remember to split
feet/inches into two fields), and one field is more work for you (creating
the procedures, handling mis-entered data, etc.).

Who are you building this for?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 

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