Automatic access ID. The data type in the standard expression does not match

I want to enter a Message ID in the text box to query the message content. However, the Data Type mismatch in the standard expression of the automatic number in access is blocked. After analysis, view the information and find a solution. Here we will share the text box named txtyhid. If it is written as Stringsql

I want to enter a Message ID in the text box to query the message content. However, the Data Type mismatch in the standard expression of the automatic number in access is blocked. After analysis, view the information and find a solution. Here we will share the text box named txtyhid // if it is written as // String SQL =

Enter a message in the text box.No.To query the message content,

But access isAutomaticNo.OfStandardExpressionMediumDataTypeNoMatchAfter analyzing and viewing the information, I found a solution. Here, I will share it with you.

The text box name is txtyhid.

// Write

// String SQL = "select * from yhly where lyr =" + txtyhcx. Text + "'";

// Or perform Integer Conversion String SQL = "select * from yhly where lyr =" + int. Parse (txtyhcx. Text) + "'";

// Or perform Long Integer Conversion

My solutionAutomaticNo.SQL statement Decomposition

String SQL = "select * from yhly where ID = ";

String sql1 = SQL + txtyhid. Text;