Counting Characters

G

Guest

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
 
G

Guest

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.
 
G

Guest

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Counting characters 4
Limit number of characters in a text box 5
How many characters can be displayed in a combo box? 4
Can't get text box on report to display all of text. 3
Text box bound to Memo Field 1
Counting Remaining Text Characters 2
Timer of Form 4

Top