fonts and formatting

[ssh]

I'm managing a font database and want some kind of report. The question is how to format records with fonts found in database? All the fonts are installed to system. Thanks.

 

[barbarossaii]

Hi ssh,

you can formate the fields of ur report in the design view of the report while u programm the report: click the field, open the context menu, "properties", "fomate". There u can change font, color,....


HTH,
Barbarossa II

 

[bradcccs]

If you have a listing of the font names in the db then you can use On Format of the detail section:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Me.FontNameStored.FontName = Me.FontNameStored

End Sub

Where FontNameStored is the name of the text box on the report with appropriate control source.

HTH

Brad.

 

[ssh]

Works somehow. But report shows only 2 first pages and then 'run-time error 2101: the setting you entered isn't valid for this property'. And fields are selectively shown in appropriate font, most fields are in default box font. Thinked it should have been easy but not.