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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Click to expand...

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.
 
Back
Top