Displaying only part of a field
- Thread starter Jon123
- Start date
Does it make a difference if this a subform?
On the on open event of the subforn I typed this code
Left([Module], 10) this one errored expected ='s
so I put this coed
=Left([Module],10) this one errored for expected line number
in but cases the code turned red and would not compile.
Jon
On the on open event of the subforn I typed this code
Left([Module], 10) this one errored expected ='s
so I put this coed
=Left([Module],10) this one errored for expected line number
in but cases the code turned red and would not compile.
Jon
Jon -
A little confused here. This started out as a report and it's now become a subform? In either case, the OnOpen option is probably not going to fly.
If you want to only display the first x characters of a field, then create a query and incorporate your criteria, e.g. mymodule = left([module], 10), and use that as your report / subform record source.
Bob
A little confused here. This started out as a report and it's now become a subform? In either case, the OnOpen option is probably not going to fly.
If you want to only display the first x characters of a field, then create a query and incorporate your criteria, e.g. mymodule = left([module], 10), and use that as your report / subform record source.
Bob
Sorry for the confusion my typo it is a sub report.
anyway I like the querry idea. Is there a way that I can add a field to the qry grid and have that field do an If statement rather then cutoff part of the field value?
Meaning something like this
= If [Module] = "Mainframe xxxxxx" Then [Module] = "Mainframe"
jon
anyway I like the querry idea. Is there a way that I can add a field to the qry grid and have that field do an If statement rather then cutoff part of the field value?
Meaning something like this
= If [Module] = "Mainframe xxxxxx" Then [Module] = "Mainframe"
jon
- Local time
- Today, 13:35
- Joined
- Feb 19, 2002
- Messages
- 48,081
Well which is it, do you want the first 10 characters whatever they might be or do you want only records where the field starts with "Mainframe"?
You kept putting the expression in an event property. You needed to put the expression in the ControlSource property of a control and prefix it with an equal sign.
=Left(SomeField, 10)
to put it in a query as Bob suggested, use an empty column and in the Field: field put:
Left10Name:Left(SomeField, 10)
You kept putting the expression in an event property. You needed to put the expression in the ControlSource property of a control and prefix it with an equal sign.
=Left(SomeField, 10)
to put it in a query as Bob suggested, use an empty column and in the Field: field put:
Left10Name:Left(SomeField, 10)
