Textbox showing different version of a number in report.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • AccessBeetle
    New Member
    • Jul 2009
    • 111

    Textbox showing different version of a number in report.

    I have report which has a numerical field called FundID. When I enter some number like "199019" in that field in data entry form. But when it print the report it shows something like "1E+04".
    Where to look at for fixing this.

    any thoughts on what is going on?
    Thanks
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Have a look at the "Field Size" property of the field FundID in the table.

    Make sure the field size is set to Long Integer.

    Comment

    • AccessBeetle
      New Member
      • Jul 2009
      • 111

      #3
      It is set to Long Integer.
      Thanks

      Comment

      • ajalwaysus
        Recognized Expert Contributor
        • Jul 2009
        • 266

        #4
        Originally posted by AccessBeetle
        It is set to Long Integer.
        Thanks
        Is there any chance that the field itself is too small to hold it, just make the text box wider?

        Shot in the dark.
        -AJ

        Comment

        • AccessBeetle
          New Member
          • Jul 2009
          • 111

          #5
          Cool...
          Your shot in the dark perfactly worked.
          Thank you much!!

          Comment

          • ajalwaysus
            Recognized Expert Contributor
            • Jul 2009
            • 266

            #6
            Originally posted by AccessBeetle
            Cool...
            Your shot in the dark perfactly worked.
            Thank you much!!
            Well glad we could help. That's what we are here for. =)

            -AJ

            Comment

            Working...