how do you upload form comments to a Microsoft Databse?

[xstortionist]

Hi, I'm back with yet another question that has been on my mind for the past week.

I created a basic form for uploading leads into a MDB (Microsoft Office Access) database. The problem I have run into is that it only allows you to upload a maximum of 50 characters and it only outputs a maximum of 50 characters.

How do I upload form comments to a database that allows you to upload more than 50 characters?

help would be greatly appreciated.

[Newsgroup_User]

Configure one's database to accept the amount the data you desire.

In Access:
-- a text field can be configured to hold up to 255 characters.
-- a memo filed can hold up to ~2 million characters.

Open up your Access database and look at the field types and properties
and read the help documentation on how to use this database management
system.

[xstortionist]

Ian you are a very big help to me. I think this is exactly what I was looking for. When I get some freetime at work I'm going to create a sample database to see if this is the solution to my problem.

thanks!

[xstortionist]

Ian thank you very much for your help. I am now able to upload comments to my database without there being a character limit.

Thanks I really appreciate it.