[AccessD] Practical way to handle non-standard length "long text" fields

[Ryan Wehler]

Is there any practical way to handle non-standard VARCHAR(MAX) "long text"
fields in access?

If I set one to VARCHAR(500), Access still treats it as Long Text(MAX) and
the user doesn't really know it's going to be a problem until they exit the
field and an error pops up.

Ideally what I'd like is for access to just stop typing as it it would if
you hit the char limit for the field.  Is there a way to do that without
using OnChange or KeyDown events to count characters up and warn the user?