Upper case for control source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alylia - 20 May 2006 17:13 GMT

Hello

A label box on one of reports has in its control source =[Enter
Financial_Period] which is the criterion on which the query is based that is
attached to the report. The financial years are FY05 for 2005, FY06 for 2006
etc.

If a user enter fy05 or fy06, I would like assistance on whether these
entries can be converted into upper case if the user fails to turn on the cap
lock key.

Reply to this Message

Allen Browne - 20 May 2006 17:40 GMT

If you just want to *display* them in upper case, just set the Format
property of the text box on the report to:
>
Don't do that with memo fields: it will truncate them at 255 characters.

If you actually want to convert the entries so they are *stored* as upper
case, use the AfterUpate event procedure of the control to convert them.
Example:
Me.Text1 = UCase(Me.Text1)

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> A label box on one of reports has in its control source =[Enter
> Financial_Period] which is the criterion on which the query is based that
[quoted text clipped - 7 lines]
> cap
> lock key.

Reply to this Message

Alylia - 20 May 2006 20:12 GMT

I don't get waht you are suggesting.

Which property should be set to what?

please don't forget I am using label box

> If you just want to *display* them in upper case, just set the Format
> property of the text box on the report to:
[quoted text clipped - 17 lines]
> > cap
> > lock key.

Reply to this Message

Allen Browne - 21 May 2006 03:26 GMT

I guess I don't understand either.

It cannot be a Label control. Labels do not have a Control Source, so if it
is a label you cannot set its Control Source to:
=[Enter Financial_Period]

If it is a text box (regardless of its name), set the After Update property
of the text box to:
[Event Procedure]
Then click the Build button (...) beside this.
Access opens the code window.
The line of code goes in there, between the "Private Sub..." and "End Sub"
lines.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I don't get waht you are suggesting.
>
[quoted text clipped - 23 lines]
>> > cap
>> > lock key.

Reply to this Message

Allen Browne - 21 May 2006 03:36 GMT

To try to be a bit clearer:

1. Adding the right-angle-bracket character to the Format property of the
text box on the report will make the report print the value of that text box
in upper case.

2. The line of code goes in the property of the text box on the *form*. This
suggestion does not apply if [Enter Financial_Period] is a paramter in a
query (which is probably where I confused you.)

Therefore the first suggestion is probably all you need.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I guess I don't understand either.
>
[quoted text clipped - 36 lines]
>>> > entries can be converted into upper case if the user fails to turn on
>>> > the caplock key.

Reply to this Message

Alylia - 21 May 2006 16:13 GMT

Thanks for your support.

You are right the control was not a label box but a text box. Sorry for the
confusion. However, on reports there are no event procedures for text boxes.

Please advice

> I guess I don't understand either.
>
[quoted text clipped - 37 lines]
> >> > cap
> >> > lock key.

Reply to this Message

Allen Browne - 21 May 2006 16:51 GMT

Hopefully you saw the follow up I posted, explaining that the 2nd suggestion
is not applicable for reports.

Just take the first suggestion of setting the text box's Format property to:
>

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thanks for your support.
>
[quoted text clipped - 55 lines]
>> >> > cap
>> >> > lock key.

Reply to this Message