Forum Discussion
Codice vba report con errore runtime 2424
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
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
- 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 - Sai dirmi perché a me visualizza questa sequenza strana di immagini anziché il cerchio?
- 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
