microsoft access 2003

[sonoma1993]

How can I let microsoft access let me type more character in a cell/field or whatever they are called?

it will only let me type this much in there - Needs a database to keep track of patients, charge

i need this much togo in there - Needs a database to keep track of patients, charges and insurance biling. i need like pretty much to fit like a whole paragrap in there.

 

[Drakkon]

you should be abel to fit a whole buncha text in a cell so long as its designed to act like "Text" datatype
now if you are typing in table view you wont be able to see your entire paragraphs and would either need to make a form or connect to it with some other app to enter data in to see full paragrah views

 

[sonoma1993]

yeah, i typed it in table view, is there a way to change it? and for some reason it saved it as a access 2000 file format. i want it saved as a access 2003 file format

I found a setting that setted it from 50 character to 255 characters. i setted it to 255.

 

[EagleKeeper]

Originally posted by: sonoma1993
yeah, i typed it in table view, is there a way to change it? and for some reason it saved it as a access 2000 file format. i want it saved as a access 2003 file format

I found a setting that setted it from 50 character to 255 characters. i setted it to 255.

You can also change the field type from a Text to a Memo field.
That will allow you 64K characters.

 

[sonoma1993]

Originally posted by: EagleKeeper

Originally posted by: sonoma1993
yeah, i typed it in table view, is there a way to change it? and for some reason it saved it as a access 2000 file format. i want it saved as a access 2003 file format

I found a setting that setted it from 50 character to 255 characters. i setted it to 255.

You casn also change the field type from a Text to a Memo field.
That will allow you 64K characters.

thanks eaglekeeper, the memo field worked.

 

[SaturnX]

You can change the file format through the Tools menu I believe. Although be aware if you do this, you WILL NOT be able to modify the database using Access 2000.

Unlike other office applications, Access compatibility between versions is mediocre at best. Generally right now keeping as 2000 will be fine and keep it as cross-compatible as possible, unless of course you absolutely REQUIRE some functionality specific to 2003.

--Mark