Counting Remaining Text Characters

[Archidrb]

I have no idea what to call this. We are converting an Access backend to a
SQL backend. The database is used to create letters to clients and contains
"Comments" fields. Access seems to limit the maximum number of characters in
a single comments field to 255 characters, like Excel.

In SQL, these comments fields can be increased to hold much larger
"comments". I need to add a counter to each form that has one of these
comments fields that let's the user know how many more
characters/spaces/punctuation they can type before they reach the new SQL
maximum.

Its probably really simple, but since I don't know what that is called, I
don't even know where to look. Thanks everyone.

 

[Klatuu]

The 255 character limit is only for a text data type field. A memo field
(comments) field in Access can be up to 65,535 characters if entered through
the Access User Interface and up to 1 gig if entered programmatically, so I
don't know for sure what the issue is.
But, since I don't know SQL Server that well, I don't know where it is, but
you would have to know many characters the field will hold, then subtract the
length of the textbox value.

 

[Archidrb]

I knew there was a really simple solution. Although this does not give me a
"how many characters left", the memo field solves the problem completely. I
can't believe I have never even noticed it in that list of options.

Thanks!