Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8

    Angry Unanswered: Change Format Feild on the FLY

    I have in the in the Detail_Format Event

    Me.Price_Sub_25.Properties("Format") = "#,###.00"

    which works

    but I have a Feild with the format in it
    Format_Display = #,###.00

    so my thinking is doing this
    Me.Price_Sub_25.Properties("Format") = me.Format_Display

    yes Format_Display is a hidden feild on the report'
    but it does not Work why ?????

    what am i missing
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    I have even tryed

    Me.Price_Sub_25.Properties("Format") = Chr(34) & Me.Format_DispLay & Chr(34)

    still no go
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    For clarity and disambiguation purposes (Format being the name of a property), I renamed the second textbox (the one supposed to contain a format) to Text_Format.

    I'm not sure whether it's what you're looking for or not, however this works:
    Code:
    Private Sub Text_Format_AfterUpdate()
    
        Me.Price_Sub_25.Format = Me.Text_Format.Value
        
    End Sub
    Attached Thumbnails Attached Thumbnails Formats.jpg  
    Have a nice day!

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    thanks Sinndho

    that work a dream
    forgot to say It for a report

    I just had this Idea that I had to use the .Properties("Format") =

    not looking at it that way.

    boss Happy

    ie

    the click sales up pop a regional screen the select it and the report open and it the right region and the currency is in the right format

    thanks again Sinndho
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  5. #5
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •