The Environmental Policy Group is collecting data on weather conditions throughout the southeast U.S.The database used for data collection is being used by field technicians throughout the region. Louisa has been asked to update the database to reduce data entry mistakes. Louisa will create some new procedures and update others in the database.
-Because Louisa's code will only be used in Access,she can use a VBA constant in the code argument to change the City field's value to proper case.Which VBA constant should Louisa use?
A)vbUpperCase
B)vbLowerCase
C)vbChangeCase
D)vbProperCase

Question

The Environmental Policy Group is collecting data on weather conditions throughout the southeast U.S.The database used for data collection is being used by field technicians throughout the region.  Louisa has been asked to update the database to reduce data entry mistakes.  Louisa will create some new procedures and update others in the database.
-Because Louisa's code will only be used in Access,she can use a VBA constant in the code argument to change the City field's value to proper case.Which VBA constant should Louisa use?
A)vbUpperCase
B)vbLowerCase
C)vbChangeCase
D)vbProperCase

Quizplus · Accepted Answer

Louisa should use the VBA constant vbProperCase, as it will change the City field's value to proper case, which capitalizes the first letter of each word and makes the rest lowercase. vbUpperCase will capitalize all letters, vbLowerCase will make all letters lowercase, and vbChangeCase does not exist as a constant in VBA.

The Environmental Policy Group Is Collecting Data on Weather Conditions