hi..

im having troubles with a report...

i have a table named "alumnos" with a text fields named "id_alumno" it's a code of 13 characters..

when i save the register in my aplication it goes well, i can see the right code for each record, but when i preview the report it gives me the code less the last character (ex. FRNA780428FCFERNANDO), instead of the last character, it shows me the next text field, this is concatenating 2 fields... and if i see for "Browse Fields" it shows me the code less the last character plus a rare character like | .. something like this
FRNA780428FC|

so i dont knwo why it is doing this... this is the code when i compose the code


[Highlight=VB] Me.txtId_alumno.Text = Mid(Me.txtAp_pat.Text, 1, 2) & Mid(Me.txtAp_mat.Text, 1, 1) & Mid(Me.txtNombre.Text, 1, 1) & _
Mid(DTPfecha_nac.Value, 9, 2) & Mid(DTPfecha_nac.Value, 4, 2) & Mid(DTPfecha_nac.Value, 1, 2) & _
CStr(UCase(Mid(strRama, 1, 1))) & CStr(rsTipos.Fields("clave"))
vbcode]

and when i save the record

VB Code:
  1. strSQL = "INSERT INTO alumnos "
  2.   strSQL = strSQL & "(id_alumno,nombre,ap_paterno,ap_materno) VALUES ("
  3.   strSQL = strSQL & "'" & Trim(Me.txtId_alumno.Text) & "','" & Me.txtNombre.Text & "','" & Me.txtAp_pat.Text & "','"
  4.   strSQL = strSQL & Me.txtAp_mat.Text & ")"

what can be wrong or what can i do...

if i put a trim on the report it shows me just the first 10 characters

so i dont knwo what can i do...

any suggest??

thx