Search results

That was pretty much what I'd come up with. The date and note fields are separate in the table. I just wanted to see if there was a way of indenting the notes as I think it makes it easier to scan the entries that way. Guess I'll stay with what I've got. Thanks all.

Yes, that's what I'm after but there is no line break in the data. The value in the field is stored as "Note text ----------- more text" and depending on the width of the field will wrap at word boundaries as appropriate.

Many thanks for the comments and suggestions. I've decided to revert to the unbounded memo field which I'm populating from the table in VBA. In the original post I indicated I was after: 10/08/2019 Note text ----------- more text 09/08/2019 Note text 08/08/2019 Note text Unfortunately the...

Thanks for the input. jdraw - it needs to be a memo field as the content of an individual note could be quite long. The structure you suggest is what I have but with the NoteText as a memo. I think that a subreport is the best approach and that gives me what I want in form view but there are...

In Access 2016 I have, as part of a bigger system, a customer table and a linked customer memo table whose purpose is to hold a chronological log of contact with the customer. Entering and storing the data is no problem. The area I need advice on is how to display it in a form. The individual...