How can I put chr$(10) into an Access 2019 table ?

[Middlemarch]

It isn't visible in the table itself. It was in earlier Access versions.

[Micron]

I don't recall that, but won't say it wasn't. Question is, it's a non-printable character so what would be the point? If it was ever visible, it makes sense to me that they got rid of it. Why would you want this?

[Middlemarch]

I'm using Access to store data and Excel connects to it and uses chr$(10) as a linefeed in pop-up comments.

[June7]

I have 2010 and AFAIK, neither Chr(10) nor Chr$(10) show as visible characters in field. If you literally see "Chr$(10)" then you see text, not LF character.

I tried to UPDATE a field with just Chr(10) and get bad results. Only combination of Chr(10) & Chr(13) shows new line in string.

[Middlemarch]

The Access version number I forget but it showed as a little black square. Not chr$(10) as text.
It can be added with Update once setting somewhere for it
Set t = CurrentDb.OpenRecordset("Select ff from Table1;")
t.Edit
t(0) = Replace(t(0), ".xx ", "." & vbLf)
t.Update
But then you cannot even edit a field with it in... the weirdest things happen.

[Micron]

I'm using Access to store data and Excel connects to it and uses chr$(10) as a linefeed in pop-up comments.

Can't you get what you want by making the table field long text and format as rtf? The cr/lf would be embedded and carry over to Excel. At least I think so.

[June7]

RTF uses html tags. I don't think Excel will interpret the tags.