R
RDB3
I need a workaround for a problem in the "Collect & Update Via Email" feature.
Users need the ability to remove data from certain fields. Normally, this
can be done by typing a space or "" into a table.
The HTML form generated by this feature accepts a space or "". But, the
table will not update (the desired result is to blank the existing field
data). It simply ignores what was sent. So, the "update" never happens.
Upon closer investigation, I find that the HTML form is storing the "" as:
<p class=MsoNormal>“â€<o
></o>
Or, when a space is entered it is stored as:
<p class=MsoNormal> <o></o>
Of course, these are valid HTML special character codes (†and ) for
quotation marks and a space respectively--but the Acccess table "rejects"
them.
So, any ideas are much appreciated for a workaround. For example, is there a
way to allow the user to enter the term "REMOVE" and then incorporate
something that would automatically replace all the fields that contain REMOVE
with a space or NULL? It needs to act directly on the table since there is no
form used. And, it would need to happen "immediately: after the record is
updated.
Thanks in advance for your help.
Users need the ability to remove data from certain fields. Normally, this
can be done by typing a space or "" into a table.
The HTML form generated by this feature accepts a space or "". But, the
table will not update (the desired result is to blank the existing field
data). It simply ignores what was sent. So, the "update" never happens.
Upon closer investigation, I find that the HTML form is storing the "" as:
<p class=MsoNormal>“â€<o
></o>Or, when a space is entered it is stored as:
<p class=MsoNormal> <o
></o>Of course, these are valid HTML special character codes (†and ) for
quotation marks and a space respectively--but the Acccess table "rejects"
them.
So, any ideas are much appreciated for a workaround. For example, is there a
way to allow the user to enter the term "REMOVE" and then incorporate
something that would automatically replace all the fields that contain REMOVE
with a space or NULL? It needs to act directly on the table since there is no
form used. And, it would need to happen "immediately: after the record is
updated.
Thanks in advance for your help.