Converting Text to Proper Case or Capital Case or Lower Case in Access

Problem:
Convert text in different format like CAPITAL CASE, lower case and Proper Case in access.

Solution:
You user StrConv fuction for all case.

OR

For UPPER CASE Use UCASE();
For lower case use LCASE();

Syntax:

1) StrConv Function:
StrConv(Target String, Conversion Type)

Target String is a string which you want to convert the string in different case.
Coversion Type:
1 – Converts the string to uppercase characters.
2 – Converts the string to lowercase characters.
3 – Converts the first letter of every word in string to uppercase.

2) UCASE and LCASE

UCASE(Target String)

LCASE(Target String)

Examples:

For CAPITAL CASE.

Select StrConv("Target String", 1); Return: TARGET STRING

For lower case.

Select StrConv("Target String", 2); Return: target string

For Proper case.

Select StrConv("target string", 3);  Return:  Target String

Extension method to check Null or Not Null in C#

we follow to check null reference.

if (o != null)
{    //Do Something}else{    //Do Something completely different}

but we follow extension method then make it easy coding like.

public static class ExtensionCommon  {    public static bool IsNull(this object obj)    {      return obj == null;    }     public static bool IsNotNull(this object obj)    {      return obj != null;    }     public static bool HasValue(this string obj)    {      return !string.IsNullOrWhiteSpace(obj);    }  }

and do code like that

if (obj.IsNotNull)
{    //Do Something.}else{    //Do Something.}

OR

if (!obj.IsNull)
{    //Do Something.}else{    //Do Something.}

Create Setup Project in Visual Studio.

I show basic setup step.

Steps:
1.Create sample windows application project.
2.Now add Setup project in same solution.

3.Select setup project.

4. Now add project output by right click on Application Folder.