Unconventional Use for Access

[Hook]

Hello All,

I am a self-taught Novice of Access, and I am working on a project to create a specialized epidemiology graph using an Access Report. It is similar to a Gannt chart, in that it graphs exposure periods, innoculation periods and symptom durations in an overlapping time-based bar graph of sorts.

I have accomplished this through a great number of text boxes with calculated values and conditional formatting which determine the color and size of the bars in the graph, but I have run into a problem with the results not appearing in Print Preview or when the report is printed.

The desired effects are displayed fine in Report View, and I have made sure that visibility is set to "Yes" and Display is "Always", and I just can't figure out what the issue could be. I have looked at some of the issues people have posted regarding subreports, but these are not subreports proper, these missing fields are text boxes with conditional values, some which display text or table values, and others that return true and are back-filled to create the colored bars of the graph.

I know that I'm trying to make the program serve a function that it is not really designed for, but I don't see what the issue could be. My formulas are all good, I haven't exceeded 754 controls.

What am I missing?

Thanks for any help that the community is able to provide.

 

[Kraj]

If it's an Access issue that'll be beyond my knowledge, but the first thing that popped into my head is that perhaps your printer drivers don't understand what Access is telling it. Have you tried printing to different printers? Have you tried printing directly to a PDF?

 

[Hook]

I have tried printing to two different printers; a b/w laserjet at my desk and a color laserjet networked to my office group. Not sure if I have the ability to print to a pdf, but printing to MS Image Writer has the same result as the printers, which is that these color-filled text boxes do not appear in the "printed" output.

 

[Simon_MT]

I do not think that when printing to pdf that the pdf or image writer looks at the On Format Event. I know with images it just picks up the first image and repeats the image on every page.

Simon

 

[JHB]

Post you database with some sample data.
It is difficult to guess to what the reason might be, if we do not have access to the database.