Field Size Message Box

[JonnyD123]

how would i display a message box when field size has been reached?



Many thanks

[June7]

If user enters more characters than text field allows, Access will popup a message.

[JonnyD123]

for me it just doesnt let the user type anything else

[June7]

Actually, the message should pop up when attempt to save the record.

If they can't type any more then that should indicate to the user they have hit limit. Users learn. Giving them a popup message they have to then always respond to will probably be more annoying.

I sometimes put a red label on form above the textbox with a note about the length limit.

If you really must, then need code that runs with every keystroke and compares the length with limit and if hits limit, gives message.