MS Access Long Text field shows hashtag ####

[Pada]

[COLOR=var(--black-200) !important][COLOR=var(--theme-body-font-color) !important]0

[/COLOR]
[/COLOR]

I have searched the solution for my MS Acccess hashtag (#'s) issue showing up in my Long Text field, I have originally posted my question at,
https://stackoverflow.com/questions/...-shows-hashtag

but I have not got an answer and am looking for more experts to help me.

I have a Current Comment (txtCurComment) field (Long Text) on a form that allow users to enter a comment. A current date will be inserted in the front of that comment automatically. Next to this field, I have a button, Archive Comment, when clicked the Current Comment will be added into the Archived Comment (txtComments) (Long Text) field below it. The Current Comment field then will be cleared out to be ready for new current comment. Users can then enter next comment and so on. For some reasons, some of my users get the hashtags (#'s) into these fields instead of their comments.
No format in the Properties of the Current Comment and Archived Comments fields. I use MS Access 2016.

Codes for the Current Comment field (Got Focus and Lost Focus events)

Private Sub txtCurComment_GotFocus()
If Not Left(Me.txtCurComment, 8) = Format(Date, "MM/DD/YY") Then
Me.txtCurComment = Format(Date, "MM/DD/YY") & ": " & Me.txtCurComment
End If
End Sub

Private Sub txtCurComment_LostFocus()
If Me.txtCurComment = Format(Date, "MM/DD/YY") & ": " then
Me.txtCurComment = Null
End If.
End Sub

Codes underlying the Archive Comment button.

Private Sub btnArchiveComment_Click()
Me.txtComments = Me.txtCurComment & " " & Me.txtComments
Me.txtCurComment = Null
End Sub

Everything seems working. I have no idea why the hashtags are showing up in those comments
fields to some users. These fields have long text datatype that should be fine with comments
messages.

Can experts please help? Thank you so much in advance.

[Micron]

cross posted here
https://stackoverflow.com/questions/77115682/ms-access-long-text-field-shows-hashtag

Pada, you should read this article
https://excelguru.ca/a-message-to-forum-cross-posters/

[mike60smart]

Why use this to add comments.

Why not just use a Continuous Subform and then there is no need for the VB Event

[Pada]

Why use this to add comments.

Why not just use a Continuous Subform and then there is no need for the VB Event

Thank you, mike60smart for your idea. I will study the continuous subform as I am not familiar with it. I have inherited this database and encountering the issue. I think users want it that way. They want enter today's comment, archive it and then later they go back to add updates and they want to see what has happened so far.

Do you think using continuous subform can eliminate the hashtags?

Thank you,

[Welshgasman]

Before you add the text, use Replace() to remove any # ?

That could be a workaround if you cannot get to the bottom of it?

[Pada]

Hi Welsgasman,
Thank you for your idea. I will consider using the Replace() function.