I'm having a problem determining where I can actually set a property to enforce the values typed into a cell in a grid to uppercase. I tried to enforce the uppercase in sql when the value was inserted but that failed.

Is there a way to use the cellvalidating event?

i.e. something like this (however this doesn't work)

private void dgFacenames_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
  {
    Convert.ToString((e.CellStyle.Format.ToUpper["facenameDataGridViewTextBoxColumn"]));
  }

Thanks in advance

Try this instead: When you go to populate the GridView with data from sql, instead of doing:

SELECT [column] from table

try:
SELECT Upper([column]) as column from table

hth

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

I would actually like to save it to the table in uppercase

I've found this as a solution but the [RowIndex] and [CellIndex] are not available in the event. Not sure how to make that work.

        private void dgFacenames_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
        {

         this.dgFacenames.Rows[RowIndex].Cells[CellIndex].Value = this.dgFacenames.Rows[RowIndex].Cells[CellIndex].Value.ToString().ToUpper();

        }