K
kelly draper via AccessMonster.com
not a question just an offering.
This is pretty cheesey but also really simple way to show icons in place of
a rating or ranking number.
this minor *epiphany*
dawned on me the other day when i was wondering
how to do this.
see, I have this 1 app. that has a section on it where a user sets a
ranking for an item. I thought it would be cute to show an icon instead of
a number when the user pulls up a record and a ranking for that particular
item comes up with its record, kinda like some search engines do. (my
particular example is I show next to the item name, 1 star for every point
it got in its ranking. 1 star for a rank of 1, 5 stars for a rank of 5,
etc.) but i didnt want to mess with programmatically coding actual jpg's or
gifs with an event procedure. I'm lazy. thats work.
so this is what i did and it came out cute.
I used the common dingbat set that just about every windows system has, I
put a hidden textbox on my form to act as an invisible placeholder for the
max possible ranking (example: i set the hidden textbox to ="JJJJJ" because
in the webdings font, J's are smiley-faces. next i put an unbound textbox
on my form and set it to =left([HiddenTextbox,[ranking]) and set its font
to webdings. what it does is show from the left, the value of the hidden
box (JJJJJ) the number of characters that is equal to that records ranking.
thus showing me 1 smiley-face,(which I actually set to stars) for a rank of
1, 2 smileys for a rank of 2, etc..
cheesy but simple and no vb required. (unless you count the left function,
but who's counting.)
This is pretty cheesey but also really simple way to show icons in place of
a rating or ranking number.
this minor *epiphany*
dawned on me the other day when i was wonderinghow to do this.
see, I have this 1 app. that has a section on it where a user sets a
ranking for an item. I thought it would be cute to show an icon instead of
a number when the user pulls up a record and a ranking for that particular
item comes up with its record, kinda like some search engines do. (my
particular example is I show next to the item name, 1 star for every point
it got in its ranking. 1 star for a rank of 1, 5 stars for a rank of 5,
etc.) but i didnt want to mess with programmatically coding actual jpg's or
gifs with an event procedure. I'm lazy. thats work.
so this is what i did and it came out cute.
I used the common dingbat set that just about every windows system has, I
put a hidden textbox on my form to act as an invisible placeholder for the
max possible ranking (example: i set the hidden textbox to ="JJJJJ" because
in the webdings font, J's are smiley-faces. next i put an unbound textbox
on my form and set it to =left([HiddenTextbox,[ranking]) and set its font
to webdings. what it does is show from the left, the value of the hidden
box (JJJJJ) the number of characters that is equal to that records ranking.
thus showing me 1 smiley-face,(which I actually set to stars) for a rank of
1, 2 smileys for a rank of 2, etc..
cheesy but simple and no vb required. (unless you count the left function,
but who's counting.)