displaying height in a table

[GazzaG]

Can anyone help me on how to display "height" in a table, ( feet & inches" when in design view I cannot see any format for height, would it come under scientific?

 

[BNPMike]

I've never come across a system that has feet-and-inches as a data type. Correctly, in the Relational Model, the valid values of a column are called domains. A domain is a finite set of possible values. Some systems do allow you to create domains (usually called enumerated scalars). Examples are MySQL and Pascal.

Use metres and calculate the feet and inches bits as defined fields in a query.

 

[JeremyNYC]

Well, using meters would be a lot of work if you always want feet and inches. Much easier would be to just store the number of inches. You can write functions to convert from inches to feet and inches for display, and can have input be done in two text boxes (one feet, the other inches), and have an invisible text box on the form that has just the inches. Code in the first two text boxes will update the invisible one when a change is made. Code in the OnCurrent event will update the first two when you go to a new record.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[SkipVought]

GazzaG

Simple.

You have a column for HEIGHT IN INCHES

Or...

You have a column for HEIGHT IN FEET



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884