Create a unique border style property for a line in Access
Posted on 2011-09-26
When creating a line in an Access report is it possible to use different border style properties other than those which appear? Except for solid lines the standard options don't work well for my needs. I would like to create unique lines that look something like "--*--*--" (two hyphens followed by an asterisk) or maybe "+++++" or "=====". The challenge is to find something that looks good when the report is published in color, but is also readable when the report is printed in black and white. No two printers print exactly alike and I have many users to satisfy.
Any suggestions would be appreciated. I'm guessing a custom border style would need to be created using VBA, so an example of how the code should be written would be very helpful.