how do i change an access number field to a text field?

[Brenda]

I downloaded the recipe collection database, but the quantity field in the
subform is set up as a number field and will only accept whole numbers and
decimals. It should be set up as a text field so that you can enter regular
cooking measurements such as 2/3. How do I change this field?

 

[Rick Brandt]

I downloaded the recipe collection database, but the quantity field
in the subform is set up as a number field and will only accept whole
numbers and decimals. It should be set up as a text field so that you
can enter regular cooking measurements such as 2/3. How do I change
this field?

Are you sure you want that? Does the app provide a way to change the servings
and have all of the ingredients automatically adjust? If so that will only work
with a numeric field.

I only bring that up because a recipe app I threw together has that feature
(after I saw the ability on several recipe web sites) so I figured it might be
common.

 

[Bob Miller]

Leave it as a number. Change to fractions in you data entry and output.
You can create a object in a form that will allow you to put in 2/3 and
have it convert to .6667. Then in your report or output form the field
would convert from .6667 to 2/3.