Forum Discussion
Solved
Codice vba report con errore runtime 2424
Buongiorno , Ho un report access con delle caselle di testo al cui interno ci sono delle cifre. Siccome in access non esistono figure a cerchio ho importato dei cerchi colorati che mi serve colorare...
One thing at a time if you don't mind...please post your crosstab query question in a new thread
I had a flash of inspiration based on something similar I've done in the past
So I have a solution for your report issue & I hope your boss is happy with the result!
It will work in report view or print preview
The coloured circles are in fact a Webdings character which is a solid black circle by default
I've then applied conditional formatting to these depending on the value of the number field
Chr(110) is in fact the letter 'n' in a standard font as you will see from the enclosed query
Forgot to say that this solution means you can alter the circle size by just changing the font size
You can also get a similar effect using other shapes such as a star. Just choose a different character or another font such as Wingdings
You can also get a similar effect using other shapes such as a star. Just choose a different character or another font such as Wingdings
- Strange. Obviously a language issue with regard to Webdings. For me Chr(108) is a four pointed 'star'.
Anyway, now you have a working solution, please mark the post where i did this as the best solution.
As already mentioned, please start a separate thread for your new question as its unrelated. it will get a wider audience so you'll probably get more responses - Sono riuscito a risolvere ..Non so perché ma nel mio pc va inserito Chr(108)..grazie sei stata gentilissima..ora lavoriamo al secondo quesito?
- Io ho provato a inserire direttamente nel report il carattere wingdings e il cerchio appare con la lettera L..in struttura report mi fa vedere il cerchio correttamente ma come apro il report il cerchio diventa un altra figura..ti mando gli screenshot
- You are looking at the report in design view. I used a query for the report with a bound field called Circle. The characters shown are the word Circle in Webdings font.
I could have omitted the query and just have used an unbound field on the report
The contents of the field i.e. the circle shape is displayed in report view / print preview
