By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,054 Members | 1,327 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,054 IT Pros & Developers. It's quick & easy.

Prevent textfield from being deleted from but allow updates

P: n/a
Hi i need to prevent a textfield on a form from being deleted from but
allow updates/ append to any text already stored in the database.

How can i do this?

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies

P: n/a
On beforeupdate event of the field you can test to see what the user is
try to do to it.
For instance:

if nz(thisfield,"")="" then cancel =true

Nov 13 '05 #2

P: n/a
Disable the control that displays the data (if it's not a datasheet,
althought there may be a way[not sure]). It will appear grey-ed out,
but the data will still be displayed.

This may be better than testing for an empty string on the beforeupdate
event because, what if the user deletes the text, and replaces it with
something other than an empty string?

Nov 13 '05 #3

P: n/a
Disabling the control is great if you don't want to allow updates. You
can add a another control to accept new text to be appended, but the
existing text cannot be updated.

Nov 13 '05 #4

P: n/a
How can you disable the control and add another control to accept new
text to be appended?

Pretty new to access.


Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.