To/From Code

	Languages
BROWSEBYLANGUAGE Access VBA ASP Classic C# C++ C++/CLI Delphi Delphi Prism Java JavaScript ObjectPAL Perl PHP VB Classic VB.Net

	Categories
BROWSEBYCATEGORY +Tool Basics +Language Basics +Language Details +Data Structures +Statements +Operators +Commands +Database +OOP Basics -OOP Details Abstraction Class Helper Code Contract Constructor Destructor Inheritance-Multiple Interface Overriding Partial Class Polymorphism Prevent Derivation Static Member

	Access VBA Guides
Access VBA To/From Conversion Guides Access VBA and ASP Classic Access VBA and C# Access VBA and C++ Access VBA and C++/CLI Access VBA and Delphi Prism Access VBA and Java Access VBA and JavaScript Access VBA and ObjectPAL Access VBA and Perl Access VBA and PHP Access VBA and VB Classic Access VBA and VB.Net

Cross Ref Guide

ACCESS VBALANGUAGE

Access VBA

ACCESS VBAANDDELPHITOC

Overview

+Tool Basics

Report Tools Overview

+Language Basics

Case Sensitivity◄╣

+Language Details

+Data Structures

Array

+Statements

+Operators

+Commands

+OOP Basics

-OOP Details

	Members-Only
Sign in to see member-only pages.

► KB ► To/From Guides ► Access VBA ► OOP Details

Case Sensitivity (Cross Ref > OOP Details)

By Mike Prestwood

Access VBA versus Delphi: A side by side comparison between Access VBA and Delphi.

Language Basics

Language basics is kind of a catch all for absolute beginner stuff. The items (common names) I chose for language basics is a bit random and include items like case sensitivity, commenting, declaring variables, etc.

Case Sensitivity

[Other Languages]

Languages Focus

Case sensitiviy in this case is referring to commands and variable names. For example, are "printf" and "PrintF" equivalent? Are fullname and FullName equivalent? When you create commands, operations, methods, or variables should you worry about case?

Access VBA: No

Access VBA is not case sensitive. Like VB Classic, if you type any other case for command or variable names, Access VBA will change it to the "accepted" or "defined" case. For example, if you type msgbox it is converted to Msgbox.

Syntax Example: 1 certification question.

The following code works:

MsgBox ("hello")

Delphi: No

Object Pascal is generally not case sensitive.

Syntax Example: 1 certification question.

Variables and commands are not case sensitive.

var
 FullName: String;
begin
 fullname := 'Mike Prestwood';
 ShowMessage(fullNAME);
 SHOWMESSAGE(FULLNAME);
 showmessage(fullname);

end;

Camel versus Pascal Casing