RecordSet field name sometimes first letter is lower case

A

Alan T

I have created a recordset and tried to reference the field name but the MS
Visual Basic editor sometimes change the first letter to lower case. Why?
eg
totalValue = valueSummarySet![SumPriceValue]
changed by editor as
totalVariation = invoiceVariationsSummarySet![sumApprovedGST]

The field 'sumPriceValue' should be 'SumPriceValue' in my query.
 

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

Similar Threads

upper case lower case 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Word isn't capitalizing the first word of each sentence 2
Problem with MS Word paragraph and character styles: format getting messed up 2
How to average values from 6 different drop downs in a separate text box? 0
Working on birthday "book" for my wife and having layout/editing trouble 0
How do i stop Word chnging my name to lower case? 1
lower case letter i not always accepted 2

Top