I have a form in which I display a multitude of information relative to automobile accidents.
One of the items I wish to show is an arrow that describes the vehicles direction and movement. There are 32 possible arrows configurations (8 directions x 4 movement types (straight, right turn, left turn, U-turn)). I have these 32 arrows made in small '.gif' files and have assigned a 4-digit code to each one ( e.g. EBLT for EastBound Left Turn, NBUT, for NorthBound U-Turn, etc.)
I made a table in which I store the gifs as OLE_Objects with the 4-digit code in a text field for finding the right one.
The 4-digit lookup code is essentially calculated from 'Direction' and 'Movement' fields, which is easily done. I want to look up the appropriate gif image based on this code and display it on the form.
So, what I thought might work is to put a Bound Object Frame control control on my form and set the control source with a Dlookup formula that finds the image.
Well it finds the image, but only displays it name (EBLT.gif) with a generic icon. I find there is a "Display Type" property associated with the Bound Object Frame control which has two choices - "Content" or "Icon", and I have it set to "Content" but still get the icon.
Where am I going wrong?