Skip to main content
Inspiring
September 2, 2008
Question

how do you upload form comments to a Microsoft Databse?

  • September 2, 2008
  • 1 reply
  • 445 views
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.
This topic has been closed for replies.

1 reply

Inspiring
September 2, 2008
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.
Inspiring
September 2, 2008
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!
Inspiring
September 3, 2008
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.