Counting Characters

D

Derek Wittman

Good afternoon,
I'm struggling somewhat with a form I've created. I need to make a text box
that can permit over 255 characters in it and save the entire text box as a
field value. In lieu of that, I can force the user to complete multiple text
boxes. However, in order to do that, I'd like each text box control to have
a counter that updates the counter on each OnChange based on the len()
function of the text in the box.

Can I...

A) Have a text box that receives more than 255 characters and merely save it
using VBE to several fields? or should I...

B) Use the counter method for the user's reference to know when s/he needs
to move to the next 255-char limit text box?

Any suggestions would be appreciated. Also, if the decidedly best answer is
B, can someone help me with the coding? The len() function doesn't seem to
like the text box... perhaps it's because the control is basically 'dirty'.

Thank you in advance!

Derek
 
F

fredg

Good afternoon,
I'm struggling somewhat with a form I've created. I need to make a text box
that can permit over 255 characters in it and save the entire text box as a
field value. In lieu of that, I can force the user to complete multiple text
boxes. However, in order to do that, I'd like each text box control to have
a counter that updates the counter on each OnChange based on the len()
function of the text in the box.

Can I...

A) Have a text box that receives more than 255 characters and merely save it
using VBE to several fields? or should I...

B) Use the counter method for the user's reference to know when s/he needs
to move to the next 255-char limit text box?

Any suggestions would be appreciated. Also, if the decidedly best answer is
B, can someone help me with the coding? The len() function doesn't seem to
like the text box... perhaps it's because the control is basically 'dirty'.

Thank you in advance!

Derek
Click to expand...

Make the field in the table a Memo datatype, not Text.
A Memo field can contain 65000+ characters
 
D

Derek Wittman

Dude! That's great! I don't think any of my users will have a problem with
that! I'll have to check out the Memo in my Access book and see the
advantages and disadvantages!

BTW, I did get my character counter to finally work, counting from 255 down
to 0 in another control...

Thanks!
Derek
 
P

PC Datasheet

Go back to your table and change the fields data type to Memo. A Memo field
can hold up to 64,000 characters.
 
D

Derek Wittman

Thanks, fredg and PC Datasheet!

What I read about Memo datatypes are that you can use alphanumerics. Does
this include the Ctrl-Enter combination to keep the cursor in the unbound
textbox control on the form?

Thanks!
Derek
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Word OLE to check spelling in text box 1
OLE Word spelling 0
Template with fields and premade texts.. 0
Clearing combo boxes and a text box 2
Change Style to 'Keep with previous' instead of Keep with Next 1
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Formating bolded text exclusively. 0

Top