Text Field Capitalization

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Using Acc2000 on Windows Vista OS:

I have a text field in a table with no validation nor formatting. I am trying to set its value to 'MWest', but access is changing it to 'Mwest'.


Andy
.

Relevant Pages

  • Re: Validation problems
    ... code the formatting validation worked fine and also the validation on ... two letters followed by 6 numerics followed by one letter) - BUT only ... Me too, as it works fine for me, formatting and validation. ... If Target.Cells.Count> 1 Then Exit Sub ...
    (microsoft.public.excel)
  • Re: Validation problems
    ... Am I applying the validation to the wrong ... Exit Sub ... MsgBox "End time cannot be earlier than start time" ... have used Chip Pearson's code to help with the formatting of the times, ...
    (microsoft.public.excel)
  • Re: Zip Code Validation - length =5 or 9
    ... Try setting your Validation to "Custom", not Whole Number, for you data range... ... the users don't have to worry about the dash ... the OP almost had to be formatting his column as Text. ...
    (microsoft.public.excel.misc)
  • Re: Flash Memory is 1 GB but it shows 8MB only!
    ... This Flash Memory is working fine on Windows Vista, ... Someone has given me the web address to download one software but that is for formatting not to make full size partation. ... BTW, for normal use, no special formatting software is needed for removable flash memory -- the usual FAT format command does it properly. ...
    (microsoft.public.windowsxp.general)
  • Re: Validation problems
    ... Exit Sub ... MsgBox "End time cannot be earlier than start time" ... have used Chip Pearson's code to help with the formatting of the times, ... When I set the validation of the cells in the 'end time' ...
    (microsoft.public.excel)