Sort buttons

  • Thread starter Thread starter Mike NG
  • Start date Start date
M

Mike NG

How easy is it to create a button that has a piece of text and toggles
between an up arrow and a down arrow, like you see in the headings of
outlook express for example for sorting different columns

All I need to do is change the RowSource property of my listfield to
nominate the different queries, but it's the button I am having trouble
with
 
How easy is it to create a button that has a piece of text and toggles
between an up arrow and a down arrow, like you see in the headings of
outlook express for example for sorting different columns

All I need to do is change the RowSource property of my listfield to
nominate the different queries, but it's the button I am having trouble
with
Click to expand...
PS - Office 2000
 
PS - Office 2000
Click to expand...
I've found a reasonable workaround which I'm happy with which involves
using a font of Marlett and the text 3, 4, 5 or 6 on a command button.
However, is there a way I can make my column headers on my list field
look like a command button
 
Mike said:
I've found a reasonable workaround which I'm happy with which involves
using a font of Marlett and the text 3, 4, 5 or 6 on a command button.
However, is there a way I can make my column headers on my list field
look like a command button
Click to expand...

Presumably your "column headers" are label controls. If so,
you can set their SpecialEffect property to Raised so they
look a lot like a command button. Label controls that are
not attached to another control also provide a Click event
that you can use to change the list box's RowSource.

OTOH, why not use command buttons instead of labels,
command buttons can do every thing a label can do (except
BackColor) plus they react to a mouse click by "depressing"
and they have a Picture property so you can assign them an
icon instead of a caption.
 
Presumably your "column headers" are label controls. If so,
you can set their SpecialEffect property to Raised so they
look a lot like a command button. Label controls that are
not attached to another control also provide a Click event
that you can use to change the list box's RowSource.
Click to expand...
I only have column headers yes/no option and only SpecialEffect
attribute changes the listbox's border
OTOH, why not use command buttons instead of labels,
command buttons can do every thing a label can do (except
BackColor) plus they react to a mouse click by "depressing"
and they have a Picture property so you can assign them an
icon instead of a caption.
Click to expand...
Cos it's a bit of a nuisance lining them up above the list box. I find
it a nuisance to draw my forms - snap to grid is turned on, but it
doesn't seem to work for me
 
Presumably your "column headers" are label controls. If so,
you can set their SpecialEffect property to Raised so they
look a lot like a command button. Label controls that are
not attached to another control also provide a Click event
that you can use to change the list box's RowSource.

OTOH, why not use command buttons instead of labels,
command buttons can do every thing a label can do (except
BackColor) plus they react to a mouse click by "depressing"
and they have a Picture property so you can assign them an
icon instead of a caption.
Click to expand...
Just found I need to use ListView ActiveX, but can't see RowSource
property and seems way to complex for a beginner like me

I'll stick with the simple list with buttons on top
 
Mike said:
I only have column headers yes/no option and only SpecialEffect
attribute changes the listbox's border
Click to expand...

I didn't realize that you wanted to restrict youself to only
use the list box. List boxes do not provide any kind of
"cell" formatting, so you're secerly limited in what you can
do.

If you can provide alias names for the column headings in
the query and use a font with some graphic characters, you
might be able to get close to part of what you want, but no
way can you make it look like a button.

As far as clicking in the heading "cells", you can use the
MouseUp event procedure to provide the coordinates of where
the mouse click occured.

All this fooling around is why I always use a continuous
subform in a real application instead of a list box.

Cos it's a bit of a nuisance lining them up above the list box. I find
it a nuisance to draw my forms - snap to grid is turned on, but it
doesn't seem to work for me.
Click to expand...

Did you set the grid size (using the form's GridX and GridY
propreties)?

Don't forget that you can set the controls Left, Top, Width
and Height properties in the property sheet.
 
All this fooling around is why I always use a continuous
subform in a real application instead of a list box.
Click to expand...
Way too advanced for me right now

I can live with my listbox thanks
 
Back
Top