Accessing "write buffer" with VBA

  • Thread starter Thread starter Tim Demijohn
  • Start date Start date
T

Tim Demijohn

I'm attempting to read the number of characters in a bound
memo field in a form. I can use the len() function when I
enter the field and after I leave the field, but I cannot
count the characters during a user update. How can I
access the temporary buffer area that Access uses to count
(use the len function)? (any other ideas to solve this
problem are welcome.)
 
Tim Demijohn said:
I'm attempting to read the number of characters in a bound
memo field in a form. I can use the len() function when I
enter the field and after I leave the field, but I cannot
count the characters during a user update. How can I
access the temporary buffer area that Access uses to count
(use the len function)? (any other ideas to solve this
problem are welcome.)
Click to expand...

I *think* what you are after is the length of the displayed text in the
field while the user is updating it, as for example in an event
procedure for the Change event. This is available via the control's
Text property, which can only be accessed while the control has the
focus. So, given that the control has the focus, you can get the length
of the text as it is edited with

Len(Me!txtMyMemoField.Text)
 
Back
Top