Solved Listbox (1 Viewer)

[cheekybuddha]

I used a font called Consolas.

I guess you don't have it installed (The one in your screenshot is different).

Pick a fixed-width font.

Remember to size the label to fit.

 

[deletedT]

Changed the font to Courier New. Still the same.
Changed the font to Consolas . Still the same.

Note: It seems it's because of the space you've used between letters. If I delete the space between letters, it works.

 

[cheekybuddha]

OK

Can you show a screenshot of the label in design view as it was before you removed the spaces?

 

[deletedT]

I've already shown it in #18 post.

I'll upload another one in design view in a minute.

 

[cheekybuddha]

In design view

 

[deletedT]

this is the label and its Format property sheet.

Edit: The property sheet belonged to the form. I updated the image.

 

[deletedT]

Now that I think more carefully, it may be my side problem. My Locale in control panel is set to Japanese. And I had at least another problem with a download here. Everybody was insisting the file is OK, but it didn't work for me.
So this may be another instance of the problem caused by Windows Locale. If it works for you, you can ignore my comments.

 

[cheekybuddha]

Interesting, because the font displays as Consolas in design view and the 'Z' is aligned to the edge of the listbox. In your previous image the font was different and the 'Z' displayed to three left of the edge.

 

[cheekybuddha]

I'm guessing you're right about the locale

 

[deletedT]

I'm guessing you're right about the locale

Maybe it's better to delete my posts to prevent confusing other members.

 

[cheekybuddha]

It's an issue that could affect other users with different locales so I think better to leave them.

 

[kavehrad]

I have tried to do that but it doesn´t work. I attach my DB here. Maybe I did something wrong

Heres an example. I only did up to letter f but it should give you the idea.
Note that I changed your table name and listbox name. I wouldnt use special characters in names and wouldn't name a listbox the same as a field.

It´s perfect thank you

 

[MajP]

I think you can get a nicer aesthetic with a tab control. And a lot easier IMO and code is still one line.

Private Sub tabOne_Change()
  Me.Namn.RowSource = "SELECT ID, Namn FROM [Tbl-Kund] WHERE Namn LIKE '" & Chr(65 + Me.tabOne.Value) & "*';"
End Sub

 

[Dreamweaver]

I did something like this not with a list but with a datasheet

I might make another example of it as did it 15 years ago

 

[cheekybuddha]

Is that 27 toggle buttons, Mick?

 

[Dreamweaver]

Think so, To be honest I hadn't looked at it in so long.

 

[Dreamweaver]

Just added an example of the filter form.

Database Dreams

databasedreams.createaforum.com

 

[June7]

Consolas font works for me.