If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Frame Text display problem
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. -- Kimon |
#2
|
|||
|
|||
Frame Text display problem
Me!Total.ControlSource = "=Format(0, 'Currency')"
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Kimon" wrote in message ... 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. -- Kimon |
#3
|
|||
|
|||
Frame Text display problem
I wrote it but it doesn't work
-- Kimon Ο χρήστης "Douglas J. Steele" *γγραψε: Me!Total.ControlSource = "=Format(0, 'Currency')" -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Kimon" wrote in message ... 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. -- Kimon |
#4
|
|||
|
|||
Frame Text display problem
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')" -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Kimon" wrote in message ... I wrote it but it doesn't work -- Kimon ? ??????? "Douglas J. Steele" ???????: Me!Total.ControlSource = "=Format(0, 'Currency')" -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Kimon" wrote in message ... 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. -- Kimon |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need Feedback on table setup | Little Penny | Database Design | 1 | December 28th, 2005 11:32 AM |
Edit/Add record in form from cmdButton | doodle | General Discussion | 3 | December 28th, 2005 03:06 AM |
Newbie Looking for Help | Little Penny | Using Forms | 6 | December 27th, 2005 08:33 PM |
Is Access even the right idea? | BMB | New Users | 19 | November 21st, 2005 08:01 PM |
Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 PM |