Images from SQL Server

I'm populating an Access continuous form with lots of icons from a SQL
Server backend. If I remove the field holding the icons from the
stored procedure, the form loads 5X faster. Is there any sort of trick
to improve the performance of this sort of scheme?
lqHi

The loading of the form is not just the returning of the dataset, but also
the conversion of the data into the icon. You may want to test the speed of
the queries through query analyser. You may also want to validate if the
size and datatype of the column to see if you can cut the size down, another
alternative is to load the icons from disk and only have references to them
in the database.

HTH

John

"Lauren Quantrell" <laurenquantrell@.hotmail.com> wrote in message
news:47e5bd72.0311080647.2655d2f3@.posting.google.c om...
> I'm populating an Access continuous form with lots of icons from a SQL
> Server backend. If I remove the field holding the icons from the
> stored procedure, the form loads 5X faster. Is there any sort of trick
> to improve the performance of this sort of scheme?
> lq

Iif Functions

In a table im populating I have to leave a data cell blank depending on the
value retrieved.
eg. if the breed type is deer leave the cell blank.
Do i use an Iif function for this or not. And if so how do I write it.
Total sqlnewbie here.
I have this so far....Iif(Fields!Breed.Value = Deer......... not sure
what should come next.Put it in the Visibility/hidden property: ....Iif(Fields!Breed.Value ="Deer", True, False)
"Nat Johnson" wrote:
> In a table im populating I have to leave a data cell blank depending on the
> value retrieved.
> eg. if the breed type is deer leave the cell blank.
> Do i use an Iif function for this or not. And if so how do I write it.
> Total sqlnewbie here.
> I have this so far....Iif(Fields!Breed.Value = Deer......... not sure
> what should come next.