Hi all,

I've read a few old posts on this point in this and other groups, but
want to see if newer versions of access has made this a viable option.

I have a form / subform combination. The subform is displayed as a
datasheet. I have a field in the datasheet which returns a value of
either 1 or Null. Instead of displaying the 1, I want to display a
small icon or a unique character (e.g., flag from wingdings). Is this
now possible, or I am hosed? If it is possible, any thoughts on getting
started would be helpful.

Best,

Kelii

so put the flag from wingdings in there

im not sure I understand the problem
have you tried 'conditional formatting'?

-Aaron



Kelii wrote:
> Hi all,
>
> I've read a few old posts on this point in this and other groups, but
> want to see if newer versions of access has made this a viable option.
>
> I have a form / subform combination. The subform is displayed as a
> datasheet. I have a field in the datasheet which returns a value of
> either 1 or Null. Instead of displaying the 1, I want to display a
> small icon or a unique character (e.g., flag from wingdings). Is this
> now possible, or I am hosed? If it is possible, any thoughts on getting
> started would be helpful.
>
> Best,
>
> Kelii

aaron,

yep, tried it, haven't been able to get it to work. i get some weird
box text in the field, which led me towards the path of using an icon,
which has resulted in even less success.

So, is it possible to display an icon in a datasheet field?

Kelii

yeah.. wierd text is what a wierd font will provide.. right?

you need to give more information; exactly what experience are you
looking for.. a button in datasheet that someone can click on ?

I would just lean towards using a continous form instead

-Aaron



Kelii wrote:
> aaron,
>
> yep, tried it, haven't been able to get it to work. i get some weird
> box text in the field, which led me towards the path of using an icon,
> which has resulted in even less success.
>
> So, is it possible to display an icon in a datasheet field?
>
> Kelii

Aaron,

I could simulate a datasheet and locate an icon in the form in this
manner. Although this is less than elegant, I suppose it will have to
do.

As a follow up to your question, I'm looking to show a simple piece of
text (i.e., the flag), or ideally a pretty icon in the last field of a
subform (datasheet view). The text or icon will appear if certain
criteria (based on other pieces of the record) are met (i.e., price
variations). I am not looking to place a button in the field.

Kelii

can't you just use 'conditional formatting' and an X or something
simple ?

If a value is between 40 and 60 then display X?

I've previously done something like this in the sql statement

Select IIF((Select MySubQuery from SomeOtherTable) BETWEEN 40 and 60,
'X', ''), TheRestOfMyQuery
>From MyTable
WHERE MyWhereClause

-Aaron



Kelii wrote:
> Aaron,
>
> I could simulate a datasheet and locate an icon in the form in this
> manner. Although this is less than elegant, I suppose it will have to
> do.
>
> As a follow up to your question, I'm looking to show a simple piece of
> text (i.e., the flag), or ideally a pretty icon in the last field of a
> subform (datasheet view). The text or icon will appear if certain
> criteria (based on other pieces of the record) are met (i.e., price
> variations). I am not looking to place a button in the field.
>
> Kelii

"unknown" wrote:

> You can use continous forms and mimic the datasheet UI

I think that I'm convinced that simple is better in this case. I've
tried simulating the datasheet and its practically worthless / doesn't
look very good.

I'm going to run with your idea of using an X, red background, white
bold text (using conditional formatting). Its super simple and I've
gotten nowhere with the icon / wingdings / simulated datasheet.

Thanks again for the discussion.

Kelii

yeah... I've done a lot of crazy stuff with subforms in continous
format.. it's really a nice effect

like I've built this point of sale system that looks like a datasheet--
but it has a simple yellow bar on the current item-- it's a nice eye
pleaser..

I basically used a subquery like that; and a lot of requerying of the
subform... it wouldn't work as well if I was summarizing a bunch of
data

I just would talk more about the problems you have with continous
forms; i think that they're a really nice effect

-Aaron

Kelii wrote:
> I think that I'm convinced that simple is better in this case. I've
> tried simulating the datasheet and its practically worthless / doesn't
> look very good.
>
> I'm going to run with your idea of using an X, red background, white
> bold text (using conditional formatting). Its super simple and I've
> gotten nowhere with the icon / wingdings / simulated datasheet.
>
> Thanks again for the discussion.
>
> Kelii

"Kelii" wrote:

> I think that I'm convinced that simple is better in this case. I've
> tried simulating the datasheet and its practically worthless / doesn't
> look very good.
>
> I'm going to run with your idea of using an X, red background, white
> bold text (using conditional formatting). Its super simple and I've
> gotten nowhere with the icon / wingdings / simulated datasheet.
>
> Thanks again for the discussion.
>
> Kelii
>
> In a continous form you can use Graphic buttons with real image or icons on them. no need to mimic the icons.