memo field

[mrMika]

I am converting one of my text fields to a memo field and have a couple of questions.

1) I put in an input mask and found that it only allowed 125 characters in it? Should I be able to put in more.

2) Is there a way to eliminate the underscore when using a input mask

3) The field is unbound in the form. Is there a way to limit the length of data that the user puts in on the form

 

[lupins46]

In my opinion you should be thinking about using more fields rather than trying to structure a memo field.

 

[mrMika]

ok. any ideas on limiting the length of a textbox on an unbound form. for example I have a textbox which I want to limit to 255 characters. However, if the user exceeds that the data will be truncated. If I put in an input mask then I get an underscore which is a bit of a pain because you can't go to the end of the text (it takes you to the end of the input mask). Also, the max length on that seems to be 125 characters.

 

[mrMika]

You can ignore this post. I'm doing this a different way.

Thanks

 

[BobJacksonNCI]

1. Specifications are version-dependent.

Per Microsoft, you can find the spec's for your version by:

"You can find all of the database and project specifications by clicking Microsoft Access Help on the Help menu in Microsoft Access, typing specifications in the Office Assistant, and then clicking Search to view the "Access Specifications" topic."

For Access 2000, the maximum number of characters in a text box are 255. Unfortunately, the specifications do not include input mask.

Assuming the input mask is causing the 125 character limit, why do you want an input mask?

2. The input mask can have three sections.
First is the mask, followed by a semicolon if more section(s)
Second is an indicater to tell access whether formatting characters are saved (0) or not (1 or blank)
Follow this with a semicolon if there's a third section.
Third is the character to mark where the next typed character will land. Underscore is the default.

3. You could code an On Key event routine that would recognize when 255 characters
had already been typed and stop the User there.



HTH,
Bob

 

[mrMika]

Thanks Bob