First initial only in field on form

[Neekos]

Hey guys,

I have a table that is linked to an Excel spreadsheet that imports a few different fields such as last name, first name, etc...

i also have a form(frmBook) with a subform(frmSheet) that reflects this info, but on the form i only want the first initial of the first name to show. So im using:

initial = Left([First name], 1)
Forms![frmSheet]![First name] = initial

how do i assign the value of initial to the FirstName field on the subform? I have my code in the OnOpen event of frmSheet, but it doesnt recognize it. I get an error saying "you cant assign a value to this object".

Is it because the table is linked that i cant edit it? How do i work around this?

[mlcampeau]

Hey guys,

I have a table that is linked to an Excel spreadsheet that imports a few different fields such as last name, first name, etc...

i also have a form(frmBook) with a subform(frmSheet) that reflects this info, but on the form i only want the first initial of the first name to show. So im using:

initial = Left([First name], 1)
Forms![frmSheet]![First name] = initial

how do i assign the value of initial to the FirstName field on the subform? I have my code in the OnOpen event of frmSheet, but it doesnt recognize it. I get an error saying "you cant assign a value to this object".

Is it because the table is linked that i cant edit it? How do i work around this?

Instead of using VB to do this, why don't you just create a textbox on your subform with =Left([First name], 1) as the expression?

[Neekos]

wow - i completely overlooked such a simple solution.

Thanks!

[mlcampeau]

Not a problem. Good luck!