Recent content by soringc

  1. S

    Access 2007 - Current Event

    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...
  2. S

    Access 2007 - Current Event

    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...
  3. S

    Access 2007 - Current Event

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

    Access 2007 - Current Event

    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.
  5. S

    Access 2007 - Current Event

    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 ?
  6. S

    Access 2007 - Current Event

    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.
  7. S

    Access 2007 - Current Event

    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
  8. S

    Access 2007 - Current Event

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

    Access 2007 - Current Event

    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...
  10. S

    Access 2007 - Current Event

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

    Access 2007 - Current Event

    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.
  12. S

    Access 2007 Attachments Relative Referrence

    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...
  13. S

    Access 2007 - Report Formating at runtime

    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...
Back
Top Bottom