System Architect

Bob Collison

<div>
Hi Mate,<br />
<br />
I tried Requery and it worked perfectly.<br />
<br />
I also tried Repaint and it didn't seem to do anything. &nbsp;i.e. '#Deleted' still displayed in the fields.<br />
<br />
Tanks for the quick solution.<br />
Bob C.
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
<br />
When I delete a record in a Sub-Form and return to the 'record' the field(s) contain '#Deleted'.<br />
<br />
Is there a way to eliminate the display of the word '#Deleted'. &nbsp; i.e. Be blank?<br />
<br />
Thanks,<br />
Bob C.
</div>
</div>


Hi Experts,


When I delete a record in a Sub-Form and return to the 'record' the field(s) contain '#Deleted'.

Is there a way to eliminate the display of the word '#Deleted'.   i.e. Be blank?

Thanks,
Bob C.

Hi Mate,

I tried Requery and it worked perfectly.

I also tried Repaint and it didn&#39;t seem to do anything.  i.e. &#39;#Deleted&#39; still displayed in the fields.

Tanks for the quick solution.
Bob C.

Access 2016 - Deleted Record Fields Contain #Deleted

Hi Experts,


When I delete a record in a Sub-Form and return to the &#39;record&#39; the field(s) contain &#39;#Deleted&#39;.

Is there a way to eliminate the display of the word &#39;#Deleted&#39;.   i.e. Be blank?

Thanks,
Bob C.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.