Recent content by soringc

YES. YES.YES YES YES YES IT'S WORKING !! IT'S WORKING !! IT'S WORKING !! IT'S WORKING !! IT'S WORKING !! THANKS A MILLION. I didn't realize that you have to enable the macros every time you start Access (or maybe I didn't save it last time ...). Also, it seems that the can grow/shrink doesn't...

Len25 and Bob, I just read something interesting in "Access 2007 VBA" book by Teresa Henning, Rob Cooper, etc.. (ISBN 978-0-470-04703-3, page 354 under "Current Event" : "You can use the 'Current' event to apply custom formating to a field." and then: The 'Current' event does not fire when...

Bob, Still - not good. This is what I have so far (see attachment)

Bob, I tried it on another PC. I saved it as Access 200-2003 and I ran it on a 2003 system - same thing. I don't understand how you can see different fonts and sizes. Thanks.

Yes. I did now, after you told me. thank you. but it didn't help. It's strange that it shows on your PC and not on mine.?!?I have the characters available, because I can change them manually and see them. What can it be ?

Bob, I ran the report and all fonts are still the same throughout the whole report. They don't change as per the font fields. Is it possible that they only show on the paper? I didn't actually print it yet. I just double-clicked on the report. Should I have done something else ? Thanks.

Bob, I ran the report and it doesn't show different fonts. I just double-clicked on "crdByTopicDateQ" and tye report came up, but all fonts were the same. I don't understand. What did I do wrong? Is it possible that it would only PRINT (on paper) different fonts? Thanks

I hope it'll make it this time. (I did zip it)

Bob, Pat, Attached is the db. Please ignore the 2 errors at the beginning. I don't know where they are from. I don't see anything on the report that calls those two fields. Anyway, I'll deal with that later. Basically what I need is to read the field with the FontType and FontSize for both...

Boblarson, Thank you for responding. Unfortunately, I tried it and it doesn't execute either.

Hi, How can I use the "Current" event in Access 2007 Reports so that I can modify the format of a field at runtime ? I need to read the font type and size from a field and apply it to a memo field in the same record. Is there other event I can use ? Thanks.

Hi, How do you make an attachment field in Access 2007 to look for it's data in a folder relative to the location of Access file itself ? For example: I have the Access 2007 file in C:\Data and graphics that are called as an attachment in C:\Data\Graphics. I would like to reference the...

Hi. I’m writing a database in Access 2007 and I’m stuck in doing the following: 1. I need to center text ( a memo field) vertically in a text box (in reports). The text is a memo field in Rich text. 2. I want to be able to change the font and size of this memo field at run time (during printing...