access 2003 limit character length in MSOTextBox in page forms
Posted on 2009-06-29
*FYI, i am a beginner at this.
I have created a page within Access and saved it as an HTM for users to be able to input data through a webpage interface. This data is then feed unto a table. However, I have a field for notes that the user is required to fill in. This Notes field is an MSOTextBox. The issue I am having is that the max length for characters within the field in the table is 255 characters. When a user is typing notes in more than that, they get an error. I need to resolve this error by either doing two things.
1. Limit the field on the page to 255, so the user can not type more than 255 characters.
2. When the error box comes up, a way to put a note within to tell the user to limit their characters.
Additionally, does anyone know how to add a counter that a user can see so they know how many characters they have used and still have available?