By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,824 Members | 2,359 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,824 IT Pros & Developers. It's quick & easy.

OpenReport showing single charater for a field

P: 201
I'm opening a report via a query. I want the report to only show the first charater in the Forename filed. I've tried lots of diffrent ways but with no success. I've been using the code Left (forename, 1). Is this correct ? Where should i be using this ?

Oct 9 '07 #1
Share this Question
Share on Google+
2 Replies

P: 201
Solved it.

in the query i put a new filed with this as its name
Initial: Left([forename],1)

Then used the new field in the Report.

Easy when you know how !
Oct 9 '07 #2

Expert 2.5K+
P: 3,532
Or, in Form Design View, you could have created an unbound textbox and as its ControlSource entered:

=Left(ForeName, 1)

and it would do the job! But calculated fields in queries can come in handy for all kinds of things!

Linq ;0)>
Oct 9 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.