I want a text field to store the text in capital. In Format property I typed">" both on the form as well as the table. It displays capital on the form, it is storing in capital in the table but in reports it displays in the form that is typed. What to do?
Capital (1 Viewer)
- Thread starter Kundan
- Start date
Gasman
Enthusiastic Amateur
- Local time
- Today, 07:01
- Joined
- Sep 21, 2011
- Messages
- 14,265
I cannot replicate your problem.?
I added a new field to a table, set the format to >
Added control to a form and entered lowercase text
Moved to next record and back and it shows uppercase.
Created report for table, that control also shows uppercase.
Check your control.
I added a new field to a table, set the format to >
Added control to a form and entered lowercase text
Moved to next record and back and it shows uppercase.
Created report for table, that control also shows uppercase.
Check your control.
June7
AWF VIP
- Local time
- Yesterday, 22:01
- Joined
- Mar 9, 2014
- Messages
- 5,470
The format property setting does not save in caps. Format property does not change entered value - it is a display setting only. The saved value is what was typed. If you want to actually save in caps, that will require code (macro or VBA).
If you have this format set in table then drag field to form or report from Field List (or let wizard build form or report object), textbox will adopt the format setting. Otherwise, manually set the property.
If you have this format set in table then drag field to form or report from Field List (or let wizard build form or report object), textbox will adopt the format setting. Otherwise, manually set the property.
In the attached db I have typed "alabama" in PLACE field. It shows capital. But when I click PRINT ENVELOPE it prints in lower case.
My God!!! Its tedious to do this for all the reports. Once it is stored in the table in capital all reports connected to it should automatically print capital. Why isn't it so?
Because the Format does NOT store the value in the table as capitals (uppercase). Format only affects the display.
That's a good solution. Thanks. GOD BLESS YOU!!!!!!!!!!!!!!
Gasman
Enthusiastic Amateur
- Local time
- Today, 07:01
- Joined
- Sep 21, 2011
- Messages
- 14,265
You have already been told, it only affects the display of the data.
June7
AWF VIP
- Local time
- Yesterday, 22:01
- Joined
- Mar 9, 2014
- Messages
- 5,470
@Kundan, see posts 4 and 8 for reason why data is not caps.
As already advised, if you need to modify existing data to store in caps, run UPDATE query - then use code in control AfterUpdate event to save future inputs as caps.
As already advised, if you need to modify existing data to store in caps, run UPDATE query - then use code in control AfterUpdate event to save future inputs as caps.
In a similar manner if I want to store a number in text format like"123 345". What should I do?
I want space after first 3 digits. What will be the format to display and the code to store it.
Gasman
Enthusiastic Amateur
- Local time
- Today, 07:01
- Joined
- Sep 21, 2011
- Messages
- 14,265
Thanks. GOD BLESS YOU!!!!!!!!!!!
Gasman
Enthusiastic Amateur
- Local time
- Today, 07:01
- Joined
- Sep 21, 2011
- Messages
- 14,265
Thank you, but all I did was Google the question, and AWF came top of the list?
Can we use an Input Mask to ensure all that is typed is in capital? How? Will it store the typed value in capital?
