Swap Image For Field Value in Continous Forms Mode

M

MBoozer

Don't ask me why, but can you substitute an image for a yes/no field on a
subform that is set to "continuous forms" mode so that a yes value displays
one image while a no value displays another for "each seperate record" on the
subform? Normal convention would say yes but normal coding will show that the
yes image will be visible for all records being displayed and vice versa in
the continuous forms mode.
 
A

Arvin Meyer [MVP]

Yes. But not using unbound controls in a form. What you need to do is to
build a table with 2 fields: a Boolean (yes/no) and an OLE field. Add 2
records to this table; a true, with its associated bitmap in the OLE field,
and a false with its associated bitmap.

Use a query to join your data table to this new table. In a continuous form,
the bitmaps will display properly because they are bound to the underlying
data.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top