Limited a memo field to 1000 characters

access my brain · Sep 19, 2003

Is there a way to limit the character size for a Memo box?.

I need to get the Memo box to stop at 1000 characters when the user is typing and just stop typing like a text box, which limits you to 255 characters.

Can anyone post some example code for this?!?

thanks!

Mile-O · Sep 19, 2003

As far as I can tell you can't stop it the way you'd like due to the Key events: KeyDown, KeyPress, and KeyUp.

It seems that after the last event fired (KeyUp) the code is run but the next letter is inserted after the event is complete.

Fizzio · Sep 19, 2003

Try this code in the control to be controlled...

Code:

Private Sub YourControl_KeyDown
If Len(me.YourControl.Text) => 1000 and Keycode <> vbkeydelete and keycode <> vbkeyback Then
KeyCode = 0
End If

This is something that would work well as a custom function / Sub so that you could use it for a selection of controls.

dcx693 · Sep 19, 2003

Fizzio, it works, except now the user can't edit anything inside the text box.

Mile-O · Sep 19, 2003

Probably best to rewrite the code to check the SelStart is not at the allowed Len.

Fizzio · Sep 19, 2003

dcx693 said:
Fizzio, it works, except now the user can't edit anything inside the text box.

So what

Cheers Mile-O

dcx693 · Sep 29, 2003

Hey guys, I was just leafing though my Access 2000 Developers Handbook and chanced across a solution to this exact problem. It involves using a Windows API function. It's a bit too long to type out here (and I'm sure some copyright issues are involved

), so I'll just point you to it. It's page 474 under "Using SendMessage to Limit Input Characters".

Limited a memo field to 1000 characters

access my brain

New member

Mile-O

Back once again...

Fizzio

Chief Torturer

dcx693

Registered User.