Switchboard- Programming a dashboard

[armyofdux]

Im trying to setup a rudimentary dashboard. I have some unbound text boxes that I would like a value to appear in. I have one portion working fine. Basically, I want the copied code to display in each of these unbound text boxes.

Private Sub Form_Load()


Me.Record_Count = DCount("*", "Assets")
Me.AssetValue = DSum("[Sale Price]", "Assets")

The Record count one obviously gives me the number of asset records I have in my asset table. What I am trying to do next is have the code display a currency formatted sum. So it would automatically sum all the sale prices in the assets table.

What am I missing? I am racking my brain on this. I know it's something simple. Right now it just gives me that error.

[Shadow9449]

What happens when you expand that box so it can display more digits? It may not have enough room and thus showing it as an exponent.

[armyofdux]

Shadow that was it! Box just needed to be bigger... thanks!

[Shadow9449]

Most welcome!