Share via

set Format of text field in Table to Uppercase - shouldn't it display uppercase on forms and reports

Anonymous
2020-05-23T20:48:59+00:00

I set the format for the text fields of a Table to be Uppercase with the > in the Format properties in Design view of the table.

I thought that no matter where that Text is displayed it should show Uppercase - Like in Forms and Reports.

I just went in and set the Text boxes on the Forms in the Properties to be Uppercase- didn't think I needed to do that.

How about Reports???

Do I have to also go in and set the Text box property to > of those Also??? Crazy?

I know its not Storing it as uppercase in the table but just thought it would carry through.

Thanks,

bkel

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-06-16T20:21:38+00:00

    I applied your code to the Forms - which worded Great

    Public Function ConvertToCaps(ByRef KeyAscii As Integer)

    ' Converts text typed into control to upper case

       Dim strCharacter As String

       ' Convert ANSI value to character string.

       strCharacter = Chr(KeyAscii)

       ' Convert character to upper case, then to ANSI value.

       KeyAscii = Asc(UCase(strCharacter))

    End Function

    Then in the KeyPress event procedure of the control in question put:

        ConvertToCaps KeyAscii

    Below is From a Previous post of yours.

    At table level the only way I can think of would be to execute a data macro which executes an SQL UPDATE statement when a new row is inserted into each table.

    I like this idea! Not sure what to put in the SQL Update statement or can I use the Access provided builder - not sure how to make it happen her.  I can do it in the After Insert and or After Update

    but not sure of the next steps to Convert it to All Caps.

    I am looking at the Design Ribbon(Tab) of the Table and see Create Data Macros with After Insert , After Update ... not sure how to Build it with the Macro Tools Screen that comes up after that.

    Thanks for Helping!!!

    bkel

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-05-26T16:38:33+00:00

    I guess you could use control events (after update) to format the input data immediately or form event to loop through all the controls and do the same.

    Another approach would be to create a query that set ask the fields to uppercase and simply run it as required.

    Was this answer helpful?

    0 comments