Frame Text display problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have the following problem, In the secondary form I have a frame text
which contain a number.
When the subform has no records (the allowadditoions = false) it must
display the value 0.00 €.
I use the folowing :
Me!Total.ControlSource = "='" & Format("0", "Currency") & "'"
but the frame texts don't display it.
 
What does "doesn't work" mean?

Do you get an error? If so, what's the error? If there's no error, what
actually shows up in the textbox?

Did you copy it exactly as I typed it (i.e.: did you notice the single
quotes around Currency)?

I'm assuming that there isn't a field named Total in the underlying
recordset for the form. If there is, try renaming your text box, say to
txtTotal, then use

Me!txtTotal.ControlSource = "=Format(0, 'Currency')"
 
Back
Top