 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2005Field Format in Forms
Ok so I have a field on a form that is controlled by a table and they both have a format of ">". Which means that all caps will be used even if someone types in lower case. It seems to work but when someone types in it using lower case it does change to upper case but when I run a report and this data shows up on the report it shows up in lower case. And when you click back in that field on the form it also changes back to lower case and then when you click out of the field it goes back to upper case. Any ideas? Format properties modify the "display" of values.  SignatureDuane Hookom MS Access MVP > Ok so I have a field on a form that is controlled by a table and they both > have a format of ">". Which means that all caps will be used even if [quoted text clipped - 7 lines] > you > click out of the field it goes back to upper case. Any ideas? It is set to "always". And it's still doing the same thing. > Format properties modify the "display" of values. > [quoted text clipped - 9 lines] > > you > > click out of the field it goes back to upper case. Any ideas? What property is set to "always"? Don't get confused with how a value is stored vs. how the data is displayed. SignatureDuane Hookom MS Access MVP > It is set to "always". And it's still doing the same thing. > [quoted text clipped - 15 lines] >> > you >> > click out of the field it goes back to upper case. Any ideas? The "display when" property on the format tab of this particular field in the form I am using. I guess I'm a little confused where this display value is. > What property is set to "always"? Don't get confused with how a value is > stored vs. how the data is displayed. [quoted text clipped - 18 lines] > >> > you > >> > click out of the field it goes back to upper case. Any ideas? The Display When property is used only to set the control's visible property if the form gets printed. If you ever wanted to print a form, you probably would not want to show command buttons. You could set their Display When to "Screen Only". SignatureDuane Hookom MS Access MVP > The "display when" property on the format tab of this particular field in > the [quoted text clipped - 25 lines] >> >> > you >> >> > click out of the field it goes back to upper case. Any ideas? Ok so how do I fix my original problem? > The Display When property is used only to set the control's visible property > if the form gets printed. If you ever wanted to print a form, you probably [quoted text clipped - 30 lines] > >> >> > you > >> >> > click out of the field it goes back to upper case. Any ideas? You have stated a condition but not exactly what you would like. I assume you want all text entered to be converted and stored in upper case. If this is correct, one method is to add code to the after update event of your text boxes like: Me.txtMyText = UCase(Me.txtMyText) You can also trap keystrokes and change the Ascii value Private Sub txtMyText_KeyPress(KeyAscii As Integer) If KeyAscii >= Asc("a") And KeyAscii <= Asc("z") Then KeyAscii = KeyAscii - 32 End If End Sub SignatureDuane Hookom MS Access MVP > Ok so how do I fix my original problem? > [quoted text clipped - 42 lines] >> >> >> > you >> >> >> > click out of the field it goes back to upper case. Any ideas? You assumed correct! Thank you very much for your help! I greatly appreciate it. > You have stated a condition but not exactly what you would like. I assume > you want all text entered to be converted and stored in upper case. If this [quoted text clipped - 56 lines] > >> >> >> > you > >> >> >> > click out of the field it goes back to upper case. Any ideas? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.