Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. st4rcutter

    SCROLLING TEXT IN A FORM

    If by scrolling you mean a scroll bar so you can limit the size of the control but still have ample room for content then yes, absolutely. If you view the properties of your control (text box) you will see a format tab. One of the options is "Scroll Bars". Change it from none to vertical...
  2. st4rcutter

    AfterUpdate event woes...

    Let me clarify by stating that the Control Source line should read: =Forms![projects]!media and the AfterUpdate is: Me!cost = Me!media.Column(1). Thanks!
  3. st4rcutter

    AfterUpdate event woes...

    I'm having trouble applying some of the other posts on this issue to mine so I am posting this... I have a simple simple form with a combo box and a textbox. Let's define them as: form = "projects" combobox = "media" textbox = "cost" The Combobox is setup to lookup values from another table...
  4. st4rcutter

    Weird behavior with the vertical yes/no property

    I found one solution although it does not seem to address the root cause. Changing the font to Arial CYR, Arial Greek, or Arial CE seems to correct the issue. The text is now displaying and printing. This has me baffled. Will continue to look for the root...
  5. st4rcutter

    Weird behavior with the vertical yes/no property

    Whenever I choose "Yes" for the vertical alignment of text on a report label I get the most bizzare result. The text completely disappears. I've tried changing font colors, background colors etc to check for white text on a white background but that is not the problem. I've tried alignment...
  6. st4rcutter

    Convert from DATE to TEXT and back again.

    I suppose that will have to work. I was curious if anyone else could/had come up with a work around. Thanks anyway Greg!
  7. st4rcutter

    Convert from DATE to TEXT and back again.

    I'm familiar with the FORMAT() and CDate() functions, but I'm having a little difficulty getting this to work on what would seem a very simple problem. Here is what I am trying to accomplish: I have a valid date format...example 7/03/2006. I determine the month with...
  8. st4rcutter

    How to retain format on a Pivot Chart

    Here is one that has always bugged me but I have never found a solution to. I have a pivot chart that I have defined a custom format to. I would like this format to be retained no matter what item you select from the various field choices. The problem is that evertime you change a value in...
  9. st4rcutter

    Sort not working for calculated week number

    Thanks PHV, That did the trick. I did try using CInt but recieved an error regarding invalid data type.
  10. st4rcutter

    Sort not working for calculated week number

    This is a new one for me. I have a database that calculates the week number based on one of two fields. Here is the expression: Week: Format(IIf([PM Tracking]![Sup FOC] Is Null,[PM Tracking]![Original FOC],[PM Tracking]![Sup FOC]),"ww") Field names [Original FOC] and [Sup FOC]are short date...

Part and Inventory Search

Back
Top