Access 2013 Memo Feld duplicating

[Silvera]

I often get revised versions of a record and make a duplicate and edit as needed.

In 13 my memo fields do not keep line structure


line 1
line 2
line3

Instead they be come one big continuous string of text.
line 1 line 2 line3

At least a space is added before each line.

Is there a fix or is this just something we have to live with?

Of note I am using my office's Dell laptop that was just "upgraded" to Win8.1 why not 10 beats me... 7 was so much better that 8 or 8.1.

[LaughingBull]

the width of the box you can set to fit the line of text length and in properties or the field select can shrink and can grow that is the best I know of unless there is some vba code that someone else know about. when you set the width the field will grow vertically.

[Silvera]

the width of the box you can set to fit the line of text length and in properties or the field select can shrink and can grow that is the best I know of unless there is some vba code that someone else know about. when you set the width the field will grow vertically.

The box is wide since some times the text data is in paragraph form and most often is list. The list are the issue since they make no sense when turned into a paragraph. Right now my only work around is to delete the paragraph and copy the info from the original record and paste that in. That does maintain the list format, but adds extra time to the recording process. The duplicate process is to save time.

[LaughingBull]

I am not sure I understand what you have. do you have one text field that you but 3 lines or 3 text fields? if you can zip the db an upload it here I can check it out.

[June7]

This is a memo (long text) field type. Apparently the 'list' text lacks CrLf characters to force multi-line. I don't know any simple way to fix this, unless the spaces between list items are the only spaces in the string.

[Silvera]

I not familiar CrLf characters, Ill have to look them up. I think the problem is that Office 2013 at least the enterprise version is unstable in both Access and Excel out of the blue when editing a form or spreadsheet things have moved (In the db is was when going from design to form view). For instance in Excel a portion of the grid shifted, I had to close and reopen to fix that. Today another database the I created had a background and one field shift by the distance of their respective length. The issue this is about is a different db that has not had forms edited only data within a field.

[June7]

I have never used Access 2013. Your profile shows using 2010.

[Silvera]

My office just "upgraded" my office laptop to Win8.1 and office 13. At home I'm still 10 and now with Win10

[June7]

CrLf = Carriage Return Line Feed

I am just now starting to do some testing with Access 2013. Not liking what I am reading about it.

[Silvera]

Thanks for the info. Our IT chief thinks 13 "IS" stable. I hope she's right.