Access 2007 Change field size setting

H

heather

I am new to access 2007 and it is considerably deifferent from 2002.

I have a field (column) which should be a catalog number. I want to enter
numbers such as 001-001, 001-002, etc and an error message keeps appearing
that " I have entereted text in a numeric field or a number that is larger
that the field size setting permits"

I have searche dthe property sheet and can not find a field that will allow
me to change the field size, also when I try and change the format from
"general number" to a text it oly gives me numerical options to choose from.
Please help if anyone can......
 
J

Jerry Whittle

A number data type can not store a - minus sign within a number. You need to
change the field's data type to Text.
 

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

Top