How do I stop someone from deleting info in a textbox?

[merlynsdad]

This time I'm just looking for theory on how to do something; I'll do the code once I figure out how I want to do this. I'm in Access 2003, using VBA. I have a textbox on a trouble ticket where the user can enter up to 250 characters to describe a situation. The user can subsequently edit this box, but we only want them to be able to add additional text, not delete what's already there. If anyone has ideas on how to approach this problem, I'm interested.

BTW, love the redesign of this input box. .

If the square peg won't fit in the round hole, sand off the corners.

 

[SkipVought]

A TextBox control should ONLY be used for user entry. If you have some boiler plate text you want to add, then add it AFTER the use enters their data.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[merlynsdad]

The user enters their problem description. If the problem clears itself before we get to it, the user can then update that textbox so we know to close the ticket. What we don't want the user to do, though, is to delete what they previously entered when they opened the ticket. Can that be done?

If the square peg won't fit in the round hole, sand off the corners.

 

[dhookom]

I would re-design the table structure so the notes are in a related table. New notes/comments always create new records. Don't allow users to edit old notes.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

Don't allow users to edit old notes.

AMEN!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}