• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

Is there a way to display a List Box without showing the vertical lines between the fields?

See attached.
Capture.JPG
0
CRB1609
Asked:
CRB1609
  • 2
  • 2
  • 2
  • +1
2 Solutions
 
GRayLCommented:
No, not in Access.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Not that I have ever seen, unless by change there is a new Property for list boxes in A2007/10 ... check the Property sheet for the List Box control.  My A2010 system is not available at the moment.

mx
0
 
Michael VasilevskySolutions ArchitectCommented:
You could change the listbox control recordsource to SELECT ID, [Field1] & " " & [Field2] & " " & [Field3] FROM [MyTable] with a column count of 2 instead of SELECT ID, [Field1], [Field2] , [Field3] FROM [MyTable] with a column count of 4.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
CRB1609Author Commented:
mvasilevsky

Yeah I thought about that but  the columns would be not aligned and it wouldn't look good.
0
 
Michael VasilevskySolutions ArchitectCommented:
you could force the number of characters in each field using format() but I agree it's not an ideal solution
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Well, if you use a non-proportional font such as Courier New ... and make the length of each 'position' the desired with ... using the Len() and Space() functions, you might be able to pull off something ... using what mvasilevsky suggested ... the concatenated string approach ...

mx
0
 
CRB1609Author Commented:
Thanks.  At least I know, now.

crb
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now