Need to have uppercase data from the table- but cannot make it hap

G

Guest

Hello,

I am using the table Input mask >AAAAAA to capture a six characters code
that may be letters or digit. The table shows all the collected data in
uppercase.

I capture the data through a dap page, where the uppercase text
transformation is applied, so the user always see upercase.

However, when I query the info from the table to make a chart, if it iwas
entered lowercase, all the forcing codes are not succeding to show it
uppercase. What is wrong with that?

Thanks
 
F

fredg

Hello,

I am using the table Input mask >AAAAAA to capture a six characters code
that may be letters or digit. The table shows all the collected data in
uppercase.

I capture the data through a dap page, where the uppercase text
transformation is applied, so the user always see upercase.

However, when I query the info from the table to make a chart, if it iwas
entered lowercase, all the forcing codes are not succeding to show it
uppercase. What is wrong with that?

Thanks

The input mask was not being saved with the data, so while the mask
shows you upper case, the actual data is however it was entered.

On how to save the mask with the data, see InputMask in Access help.

To show Upper case in the query, use:
NewColumnName:UCase([FieldName])

Use the NewColumnName in the chart.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top