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

Left Function in Format Property

P: n/a
In an Access Project I have a datasheet with a column of genders, and
would like them to display only the first character. Is there a way I
can add the Left(string, #) function to a property to display only the
first character of the gender?
=Left([Gender],1)

In control source produces an error.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I decided to do this in the query instead and it works.

Nov 13 '05 #2

P: n/a
AP
That should work. Is it possible that it is currently not working
because the text box you are entering the expression in is named
Gender. This would cause it to return an error. Try adding a new text
box control and enter that function into it.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.