If text does not fit in visible area of memo field

[jastek]

I want to put a check box next to a memo field that automatically gets checked if the text entered is too large to be visible without scrolling down.

In other words, if the text entered into the memo field overruns the visible size of the memo field, then a check shows up next to the field. This would tell the next person who looks at the field that they have to scroll down to see all of the text.

Is that possible?

 

[missinglinq]

I think first you need to enter text in your memo field until it's full. Count the number of characters it takes to fill it (lets call it MaxCharacters). Then set up something like

If Len (YourMemoField)> MaxCharacters Then YourCheckBox.Value = True

Not on a PC with Access right now, so can't test and give you exact syntax, but that's the general idea.

ope this helps.

The Missinglinq

 

[Mike375]

I want to put a check box next to a memo field that automatically gets checked if the text entered is too large to be visible without scrolling down.

In other words, if the text entered into the memo field overruns the visible size of the memo field, then a check shows up next to the field. This would tell the next person who looks at the field that they have to scroll down to see all of the text.

Is that possible?

You could use the Len function

Len([MemoFieldName])

and this counts the number of characters, which also includes spaces. You could then type into the memo field and see how many charcters it takes to fill the visible area and then apply that "character count" in an IIf expression.

So you could make a new field in your query

NewFieldName:Len([MemoFieldName])

and this will return the character count so you can then have

IIf([NewFieldName]>327 or whatever the number will be etc

Mike