What is the purpose, it sounds like it's simply for presentation like an excel sheet? You don't/shouldn't store blank records just as a presentation aid?
And are they really list boxes or simply large text boxes ?
If you insert a blank record what happens when someone selects it?
If it's just text then add a VbCrLf & VbCrLf to each item.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
To confirm, yes it is a list box, and i need the spaced inserted between information in a single "cell" it doesnt have to be a space in the table data per say, it just needs to show the formatting in out output of the forms list box. Hope that makes sense. Thank you.
if you are going to enforce formatting you would have to make your list a value list as opposed to a table/query ROW SOURCE TYPE property. Then insert the value in to the list when you perform your search using a method like:
https://docs.microsoft.com/en-us/off...istbox.additem
You will have to arrive at some sort of rule to properly separate your data into separate lines though.
Why a listbox? Do you still want items selectable?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Or use a continuous subform instead. Can be made to look like a listbox and you can adjust the detail height section to provide space
I agree, if you're going to try and format your text a list box is not the best way to do it.