My understanding that if an app is larger than a certain threshold (50meg?) then it won't be available to download over the 3G/EDGE network. Any apps larger than that would have to be downloaded through the user's home broadband connection into iTunes, and then synced into their devices.
Other than that, there's no real size limit, other than physical storage on the devices.